Comments by Sajid227 (Top 147 by date)

its time datatype

but problem is that if same location Id repeat again ,i have to show it in separate result,if i apply group by then it will group up all matching locationId,how can i solve this???

A bundle of thank ,and pardon me having this lengthy chit chat....

this is basically web application,but at same time it is integrate with web services,to fetch and to serve data to to other applications,although I am very much clear about my question.but you let me know some tips that help me to design my plan of deployment that application,before moving to cloud.

very briefly,I got your point.its mean without using caching we are able to upload files etc ,and that will be accessible to all user of all instances right after that. We are going to use MS Azure as well.and what if we use cache?

my requirement is that when user browse a file ,then this file is ready to play how can i do this

can you give me answer if u have got any idea?

i tried this because as this is web application so file need virtual path

i just want to play sound?ahaha give me path

yes please,in fact i am reading a pdf file using itextsharp,and file uploadcontrol,because it is time consuming ,so i use a two textbox one show total pages of file selected,and show remaing pages of that file,i did it in window form just updating that textbox,i want to do this in web form,

yes please,in fact i am reading a pdf file using itextsharp,and file uploadcontrol,because it is time consuming ,so i use a two textbox one show total pages of file selected,and show remaing pages of that file,i did it in window form just updating that textbox,i want to do this in web form,

i am using Fileupload Control??any code help ?

harsh lines of guidelines are better for my growth in development.thnx

refer some links plz

yes there is white space,as i told before that i have to save values into db,so if index change then its hard to save proper index value into into proper column of db

xxxxx_license
xxxxx
V: 0003
of mmm
User: xxx
Page No: 1
Date Wise New Regular License
Date: 26-11-2015
District: RAWALPINDI
Time: 15:16:22 FROM 26-11-2015 TO 26-11-2015
New NIC Applicant Name LP No App. Date User App. Type Allowed Vehicles
this portion is repeated through all file base on no pages,i want i file that has not that portion ,

i have not read that book,but doing properly googling i have cleared up misunderstanding,done my job too.thanx again

there are a number of record against one employee in this table ,i want to get last record of each employee in the list

thanx sir ,i am going to follow your lines.

i want that each time when employee is removed from the list ,remaining dropdownlist is updated ,showing those employee whose are not assinge yet like
pointname Employee pointname Employee
xxx 5 yyy 4
fff 3 mmm 2
sss 1

its valaue exact when is in db,problem is at the end of event when go control back browser,it does not show any value

plz any code help may you have in this way?

how can i do it with grid view?where remove of employee is done i n selected index change ,and data is bounding on ondatabounding event?

nice approach bro

one point has just one employee at one time?

1.there is may be no check box is selected or there are more than one check boxes is selected ,so i want that loop is execute only when more than one check boxes are selected or at least one check box is selected other wise it will leave it,
2.any way to optimize code that is using for dynamic text boxes:

my question is when i retrieve image using empPicture.ImageUrl,and then try to save it in db,it can not save in the db

then how to make it function properly?

When I click on the button print button does not show any dialogue box for printing

bro please change this into EF Query plz??

what nice way of description,and correction,hmmmmmmm

how??

loop is working properly it fetch employee ,problem is that it is not showing all employee record in the report separatly

u right it but problem is that i got just one record not three record separatly

i got just one record from all employee in the report,i use remove so that when employee is used up then next employee its record goes to dataset

how to handle this

how to handle this

how to tackle this

record is not updating in EmployeeCategory table//do you suggest me any other solution??

then why image is not displaying on the form when i retrieve the information about that employee

plz check this post i explained every thing in it hope you will get point

how to update sql table using other table

web form ,i want to save it first ,but when getting employee data for update purpose then image also show up on the form and can be replaced

EmployeeCategory tbl before update
id Emp_ID Sec_Id Cat_Id
1 111 1 2
if last ten records of that employee in DailyPerformance shows that his Cat_Id 'A' is more than 4 then EmployeeCategory table looks ;like
id Emp_ID Sec_Id Cat_Id
1 111 1 1
else remains unchanged

i want to update only category in the employee category table base on daily performance record

in my guery first i got day from date,then checked it for even or odd,then base on EVEN OR ODD ,i want to change the category_Id of employee in EmployeeCategory table From 1 to 2 and from 2 to one.

i am using following code
DateTime date = SafeConvert.ToDateTime(txtDate.Text);
Int16 day = Convert.ToInt16(SafeConvert.ToDateTime(txtDate.Text).Day);
if (day % 2 == 0)
{
var empcatone = (from ec in entities.EmployeeCategories where ec.Category_Id == 1 select ec).ToList();
foreach (var Empcatone in empcatone)
{

Empcatone.Category_Id = 2;



}
var empcattwo = _service.GetAllEmployeeCategory().Where(x => x.Category_Id == 2).ToList();
foreach (var Empcattwo in empcattwo)
{
Empcattwo.Category_Id = 1;

}

}
else if (day % 2 != 0)
{
var empcatone = _service.GetAllEmployeeCategory().Where(x => x.Category_Id == 2).ToList();
foreach (var Empcatone in empcatone)
{
Empcatone.Category_Id = 1;

}
var empcattwo = _service.GetAllEmployeeCategory().Where(x => x.Category_Id == 1).ToList();
foreach (var Empcattwo in empcattwo)
{
Empcattwo.Category_Id = 2;

}


}
pro\blem is that data is not updaing in respective column

thanx bro i got this idea

sir i have the following scenario, i want that when a user login in base on his last record from employee duty table in ddlsector that sector must be selected and user can not change it

i want that when an employee login ,then base on his last sector record ,sector must be selected auto,and and user can not change it.

yes EF FOR entity FRAMEWORK

yes i have update the query according to my requirement,thats work fine,i explain you further,first i want to check Employee Category from employeecategory table,then from Emplyeestatus table i have to check employee latest status, then i have to allocated duty of that employee,and there are a number of employee that have same category ,and from employee status their latest records full fill a proper requirement ,i want to collect a list of all those employee then start allocation duties according,hope u got my point

var qry1 = from ec in entities.EmployeeCategories.Where(x => x.Category_Id == 1 && x.Sector_Id == sectorId)
join es in entities.EmployeeStatus.Where(x => x.EmployeeShift_Id == 1 || x.EmployeeShift_Id == 2 && x.DutyType_Id == 3 && x.EmployeeStatusType_Id == 1) on ec.Employee_Id equals es.Employee_Id
group es by new { Cat = ec.EmployeeCategoryType_Id, EmpId = es.Employee_Id } into grp
select new
{
Cat = grp.Key.Cat,
EmpId = grp.Key.EmpId,
Es_Id = grp.Max(x => x.Id)
};
i am using this query its working good ,i want some modification, that how to get all employee latest records and check are they full filling this condition,here is my code that is full filling my needs,
.OrderByDescending(x => x.EndDate).GroupBy(x => x.Employee_Id).Select(x => x.LastOrDefault()).Where(x => x.DutyType_Id == 3 && x.EmployeeStatusType_Id == 1).ToList(); in employeeStatus table

how to get list of all employee that full fill that requirement ?

yes u right i want to get data from highest id of same employee,as there are multiple records of same employee

is there any other eway to do this??

i tried your code but problem is that it repeat same employee.i want that if there are 5 beats, and 4 emp are available ,then it fillup them,for last beat there will be a blank row against it.

yes, i want to show total row base on beats,there is emp available, then it show up otherwise blank row show up??is there any method ?

i have update the code ,i just want that when all employee against all beats fill up ,then it will move to else statement,

u are rite ,i am using two server becoz of reason that you explain

i am using same connection string ,my problem is that will we need any thing in my web config that tells the web server to connect with DB server?
<connectionstrings>
<add name="ConnString1" connectionstring="Data Source=yourSqlServerIP;Initial Catalog=YourDataBaseName;Integrated Security=True;" providername="System.Data.SqlClient">

i mean this not function properly,the code i refer is bcoz mostly it is asked by member to tell them what i have done thats way i have put them

yes u right,i just use it to check it is getting proper no records from database

yes

what??

i am using your option and storing record in these table,but i am getting record from this table EmployeeStatus,then retrive info and save this info into other record,problem is that there are a number of record against same employee,that same employee then repeated in different status,i just want that if just got last record then duplication will be end

but problem is that i have to get all the employee having same status,so i want to get last record against each employee of same status

i use improve qustion link to improve details

i have update my question now plz helpm me now

i have update my question plz help me now

whom?me or Kornfeld Eliyahu Peter,

what is it??fellow

how i insert it into database??
empStatus.IsDutiable = txtIsDutiable.Checked;
while saving its give error

I HAVE ANOTHER problem,there are three type of status type not two,like for some status type i have to show a,b,c,d fields,for other a,b,c and for last one just a,b ,then how to set them,your solution is working for two level.

both of your options are valid,i have checked this code in vs but its not works and also i need to implement it for multiple value of same drop down as explain above

BRO THANX

here is asp code of that form where i want to update the details
<label class="col-sm-2 control-label">
Roll No <span class="symbol required"></span>
</label>
<div class="col-sm-3">
<asp:DropDownList CssClass="form-control search-select" runat="server" MaxLength="7" ID="ddlRollNo" OnTextChanged="ddlRollNo_TextChanged" />
<asp:RequiredFieldValidator ValidationGroup="vgEmployee" runat="server" ID="rfvrOLL" ControlToValidate="ddlRollNo" Required="required">
<asp:Button CssClass="btn btn-green btn-block " ID="btn_Click" Width="150" runat="server" CausesValidation="True" Text="UpdateRecord" OnClick="btn_Click_Click"/>

</div>




protected void btn_Click_Click(object sender, EventArgs e)
{
var updateEmp = _service.GetAllEmployeeAbsent().Where(x => x.Emlopyee_Id == ddlRollNo.Text.ToString());


}

we have a form that can be used to change the status of employee ,like if there are 100 employee in the office mostly 10 employee status will be changed ,all the status of all employee are saved in database,i need to implement sms service that send employee his status via sms.

no that is not my requirement ,when we drag a table to the report table format is horizental,header 2nd row is data,i asked that is any way that header and data displaying in vertical manner??

var empStatus = _service.GetAllEmployeeStatus().Where( X => X.Sector_Id == select count(distinct EmpstatusType_Id ) from EmployeeStatus where Sector_Id=@SectorId);
txtSpecialDuty.Text = empStatus.ToString(); THAT query is not working
how can i get it to work

like against one sector there are some employee who may be absent,on leave or on medical, i just want show their no in the text box.

like against one sector there are some employee who may be absent,on leave or on medical, i just want show their no in the text box.

it return null

plz check my new question,How Do I Get Total Employee By Tosector_Id,here is explain the question in better way to get me out.

STILL that error
System.Linq.Enumerable+WhereSelectEnumerableIterator`2[System.Linq.IGrouping`2[System.Int16,CTP.HRMS.Business.EmployeeDuty],CTP.HRMS.Business.EmployeeCountByToSectorId]

PLZ UPDATE YOUR ANSWER THAT WILL HELP ME

after using your solution that message return in the field System.Linq.Enumerable+WhereSelectEnumerableIterator`2[System.Linq.IGrouping`2[System.Int16,CTP.HRMS.Business.EmployeeDuty],<>f__AnonymousType0`2[System.Int16,System.Int32]]

YES i want to calculate exactly

OK

i debug it now after post back it return total no of records.thanx to all guys

thanx

THEN HOW CAN I MANAGE IT

protected void btn_Click_Click(object sender, EventArgs e)
{
try
{

if (!string.IsNullOrEmpty(txtRollNo.Text))
{
Employee emp = _service.GetAllEmployee().Where(x => x.Employee_Id == txtRollNo.Text).Last();

if (emp != null)
{
Console.WriteLine("Record Found");
}
else
{
Console.WriteLine("Record Not Found");
}


}
}
catch (Exception ex) { HandException(ex); }
after trying this code an excetion is occur that state Sequence contain no element

there is no display of given result,in both cases.after debugging it return null in both condition

i also checked it using debugger

is there another solution to check the record using linq

Employee emp = _service.GetAllEmployee().Where(x => x.Employee_Id==Employee.Id).Last();
that return all field value null except for dates for both cases,if record is database or not

same result,return record found in both cases.

there is no error display by debugger

null

if i check it by entering any record that is in database or not in both case it return Record found

Employee emp = _service.GetAllEmployee().Where(x => x.Employee_Id==Employee.Id).LastOrDefault();
that is new code.

on any way that might be good

nice thanx for guideline i will address it

i was wrong i was putting fadeout in the wrong place in master page,now i put itas describe above now it is function nicely,thanx bro +5

i have that code at the end of master page,u mean to say that i have to write code just like this
<script>
jQuery(document).ready(function () {
Main.init();
FormElements.init();
$('.alert').delay(1000).fadeOut();

});
</script>
am i rite???plz help me out

i have that code at the end of master page,u mean to say that i have to write code just like this
<script>
jQuery(document).ready(function () {
Main.init();
FormElements.init();
$('.alert').delay(1000).fadeOut();

});
</script>
am i rite???plz help me out

how i use this solution to my save button,i.e if user click on save button then according to scenario message is display
http://www.codeproject.com/Tips/626350/Message-Popup-for-Errors-Warnings-Success-and-Info

<form runat="server" role="form">
<ajaxToolkit:ToolkitScriptManager runat="server">


<script>
{
$('.date-picker').datepicker({ dateFormat: 'dd/mm/yyyy' });
$('.search-select').select2();
$('.time-picker').timepicker();
$(".alert").alert().fadeOut(10000);
<%--$('<%=_alert.ClientID%>').alert().fadeOut(1000);--%>

}
Sys.WebForms.PageRequestManager.getInstance().add_endRequest(EndRequestHandler);
</script>

<asp:UpdatePanel runat="server" class="alert">
<contenttemplate>
<asp:Literal runat="server" >
<asp:ContentPlaceHolder runat="server" ID="MainContent">



when i use _alert then error and success message display,but when i click on close icon then it does not disappear ,if i use alert then no message display

bro i have solved it thanx

i tried it by taking class in updatepanel but no effect. as i used _alert then message is displayed but it does not fade away instead required field message is displayed when i fill up form again then alert message is disappeared

thanx to all i got my goal

namespace CTP.HRMS.WebApp.Forms
{
public partial class EmployeeLeaveForm : PageBase
{
protected override string ModuleName
{
get
{
return "Employee Leave";
}
}

private Employee _employee;
private Employee Employee
{
get
{
if (_employee == null)
{
if (Request.QueryString["id"] != null)
{
_employee = _service.GetEmployee(Request.QueryString["id"].ToString());
}

if (_employee == null)
_employee = new Employee();
}
return _employee;
}
}

protected void Page_Load(object sender, EventArgs e)
{
if (!MyUser.CanAccess.LeaveRecord)
{
Redirect("/Forms/Redirected.aspx", "You do not have access to this page");
}


if (!Page.IsPostBack)
{
Page.Header.Title = "Please Enter New Leave Record:";
BindData();
// PopulateData();
}
}

protected void BindData()
{
// Fill all Dropdowns
ddlRollNo.Bind(_service.GetAllEmployee(), "IdName", "Id");
ddlLeaveType.Bind(_service.GetAllLeaveType());
ddlRank.Bind(_service.GetAllRank());
ddlAllotedBy.Bind(_service.GetAllAllotedBy());
}

//protected void PopulateData()
//{
// if ( Employee.Id != null)
// {
// EmployeeLeave empLeave = new EmployeeLeave();
// txtRollNo.Text = Employee.Id;
// txtRank.Text = Employee.Rank;
// ddlLeaveType.SelectedValue = empLeave.LeaveType_Id.ToString();
// txtAllotedBy.Text = empLeave.AllotedBy;
// txtStartDate.Text = empLeave.StartDate.ToString();
// txtEndDate.Text = empLeave.EndDate.ToString();
// txtCreationDate.Text = empLeave.CreationDate.ToString();
// }
//}


protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
EmployeeLeave empLeave = new EmployeeLeave();
empLeave.UserName = MyUser.UserName;
empLeave.EntryDate = DateTime.Now;
empLeave.Employee_Id = ddlRollNo.Text;
empLeave.Rank_Id = SafeConvert.ToByte(ddlRank.SelectedValue);
empLeave.LeaveType_Id = SafeConvert.ToByte(ddlLeaveType.SelectedValue);
empLeave.AllotedBy_Id = SafeConvert.ToByte(ddlAllotedBy.SelectedValue);
empLeave.StartDate = SafeConvert.ToDateTime(txtStartDate.Text);
empLeave.EndDate = SafeConvert.ToDateTime(txtEndDate.Text);
empLeave.CreationDate = SafeConvert.ToDateTime(txtCreationDate.Text);
_service.InsertEmployeeLeave(empLeave);
_queryStatus = empLeave.Id > 0;
}
catch (Exception ex) { HandException(ex); }

Redirect("EmployeeLeaveForm.aspx");
}

protected void btnCancel_Click(object sender, EventArgs e)
{
Response.Redirect("EmployeeLeaveForm.aspx");
}

protected void txtIsPaid_CheckedChanged(object sender, EventArgs e)
{
if (txtIsPaid.Checked == true)
{
EmployeeLeave empleave = new EmployeeLeave();

empleave.IsPaid = txtIsPaid.Checked;


}
}
}
}

i tried your solution but still same result

i tried your solution but still same result

i tried your solution but still same result

<ajaxToolkit:ToolkitScriptManager runat="server">


<script>
{
$('.date-picker').datepicker({ dateFormat: 'dd/mm/yyyy' });
$('.search-select').select2();
$('.time-picker').timepicker();
$(".alert").alert().fadeOut(10000);


}
Sys.WebForms.PageRequestManager.getInstance().add_endRequest(EndRequestHandler);
</script>

and here in updatepanel
<asp:UpdatePanel runat="server">
<contenttemplate>
<asp:Literal runat="server" ID="_alert">
<asp:ContentPlaceHolder runat="server" ID="MainContent">

i have tried Your code but when i try to close alert message by clicking on cross button then different fields where required is used popup.

how to get client id in this situation

I WANT that as user enter the data jquery checked it and display error or successful message

BRO NON of them working image is dsave in database as binary data,i tried every thing that i knew but

bro i have done this,and this is working fine on each page,my requirement is ahead of this. i want after doing this user will only see that page and enter the data in that form which is allowed to him from the database table,where i store all pages name and role Id against each page,hope you got point?/

i just write name of pages in the table,how query work to fetch page or pages on this role Id

bro i have done this,and this is working fine on each page,my requirement is ahead of this. i want after doing this user will only see that page and enter the data in that form which is allowed to him from the database table,where i store all pages name and role Id against each page,hope you got point?/

bro i have done this,and this is working fine on each page,my requirement is ahead of this. i want after doing this user will only see that page and enter the data in that form which is allowed to him from the database table,where i store all pages name and role Id against each page,hope you got point?/

thanx bro your guess is true,i will keep your words in mind,sorry to WES aday,plz Forgive me

keep cool down ,u r my senior i respect u ,if can help that makes me thankful to you.

if getting knowledge from any one is begging then i am biggest beggar ,and if u feel pain of posting and system abusing teasing u then ans me and become a good teacher,all we here playing for good reason

Role table is link both User Access and log in table.
User Access and Log in both have column name Role_Id.

bro is any problem with you>> if i am posting Question,its mean may be i'm getting what i want??/or any one else ask me to explain Question,if u got my point then explain me answer, i donot like u start counting my posts.be care full

i'm using sql server

im not figer out where to start it, and how handle this problem,i'm totally blank

problem 1 is .admin of site does not has developing knowledge,he wants to give user access by just putting 1 or zero against each page title which i have created in the table of Page access with user role_id,that is requirement by admin.plz adjust it with the web that this can b e implemented,
i think after log in user will check his status from this table,and if there are 1 or 2 page access is granted using 1 or zero by admin then on front end in menu link only these form must be display.

i want solution of this trouble do u like to give example of similar problem so that i get out from this problem

bro will u send a demo code so that i can implement it,for my requirment

only one drop down .but value of that drop down different for every year, we have to get the drop down value from year of date ,

plz will u send code for this solution as a example. i like ur answer

THERE are two field at front end date is independent field but drop down is depend on the value of date entered,if user enter of any year from 2009 upto now,the dropdown must update itself accordingly,how can i do that

bro, i have a field on front end of my application followed by a drop down, i just want that if user enter date like 10-10-2009 or any date from year 2009,2010,2011,2012,2013 etc the dropdown will be show the entries of that year from database table etc.

this is my problem

yes u r rite bro,another problem is that admin of this application has zero knowledge of development ,he do not want custom solution of this problem,he asked me to set up in this way by entering 0 or 1 in the database table of page access he can enable or disable user to that page

bro, i have a field on front end of my application followed by a drop down, i just want that if user enter date like 10-10-2009 or any date from year 2009,2010,2011,2012,2013 etc the dropdown will be show the entries of that year from database table etc.

le,