public int Update(Models.MEmployees model)
{
Common.Logger l = new Common.Logger();
string ClassName = "Employees";
try
{
var query = from o in obj.Employees where Convert.ToString(o.id) == model.id select o;
foreach (var item in query)
{
item.DesignationId = Convert.ToInt32(model.DesignationId);
item.FirstName = model.FirstName;
item.FirstName = model.FirstName;
item.LastName = model.LastName;
item.DateOfBirth = model.DateOfBirth;
item.Gender = model.Gender;
item.Address = model.Address;
item.City = model.City;
item.HomePhone = model.HomePhone;
item.CellNo = model.CellNo;
item.Email = model.Email;
item.EmergencyContactNo = model.EmergencyContactNo;
}
l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] DesignationId[" + model.DesignationId + "] FirstName[" + model.FirstName + "] LastName[" + model.LastName + "] DateOfBirth [" + model.DateOfBirth + " ] gender [ " + model.Gender + " ] Address[ " + model.Address + " ] City [ " + model.City + " ] HomePhone [ " + model.HomePhone + " ] CellPhone [ " + model.CellNo + " ] Email[ " + model.Email + " ] EmergencyContactNo [ " + model.EmergencyContactNo + " ]");
obj.SubmitChanges();
l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Updated Successfully");
return(1);
}
catch (Exception ex)
{
l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString());
return(-1);
}
}
public List <Models.MEmployees> GetAllbyid(int id)
{
List <Models.MEmployees> model = new List <Models.MEmployees>();
var query = from o in obj.Employees where Convert.ToString(o.id) == id.ToString() select o;
foreach (var item in query)
{
Models.MEmployees m = new Models.MEmployees();
m.id = Convert.ToString(item.id);
m.DesignationId = Convert.ToString(item.DesignationId);
m.FirstName = item.FirstName;
m.LastName = item.LastName;
m.DateOfBirth = item.DateOfBirth;
m.Gender = item.Gender;
m.Address = item.Address;
m.City = item.City;
m.HomePhone = item.HomePhone;
m.CellNo = item.CellNo;
m.Email = item.Email;
m.EmergencyContactNo = item.EmergencyContactNo;
model.Add(m);
}
return(model);
}
public int Save(Models.MEmployees model)
{
Common.Logger l = new Common.Logger();
string ClassName = "CEmployees";
try
{
DB.Employee bs = new DB.Employee();
bs.id = Convert.ToInt32(model.id);
bs.DesignationId = Convert.ToInt32(model.DesignationId);
bs.FirstName = model.FirstName;
bs.LastName = model.LastName;
bs.DateOfBirth = model.DateOfBirth;
bs.Gender = model.Gender;
bs.Address = model.Address;
bs.City = model.City;
bs.HomePhone = model.HomePhone;
bs.CellNo = model.CellNo;
bs.Email = model.Email;
bs.EmergencyContactNo = model.EmergencyContactNo;
bs.WarehouseId = Convert.ToInt32(model.WareHouseId);
l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] DesignationId[" + model.DesignationId + "] FirstName[" + model.FirstName + "] LastName[" + model.LastName + "] DateOfBirth [" + model.DateOfBirth + " ] gender [ " + model.Gender + " ] Address[ " + model.Address + " ] City [ " + model.City + " ] HomePhone [ " + model.HomePhone + " ] CellPhone [ " + model.CellNo + " ] Email[ " + model.Email + " ] EmergencyContactNo [ " + model.EmergencyContactNo + " ]");
obj.Employees.InsertOnSubmit(bs);
obj.SubmitChanges();
l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Inserted Successfully");
return(1);
}
catch (Exception ex)
{
l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString());
return(-1);
}
}
protected void btnSaveEmployee_Click(object sender, EventArgs e)
{
if (Session["WareHouse"] != null)
{
string WareHouseId = Session["WareHouse"].ToString();
if (Page.IsValid)
{
string FirstName = txtEmployeeFirstName.Text;
string LastName = txtEmployeeLastName.Text;
string Dob = txtEmployeeDateOfBirth.Text;
string Gender = txtEmployeeGender.Text;
string Address = txtEmployeeAddress.Text;
string City = txtEmployeeCity.Text;
string HomePhone = txtEmployeeHomePhone.Text;
string CellNo = txtEmployeeCellNo.Text;
string Email = txtEmployeeEmail.Text;
string EmergencyContactNo = txtEmployeeEmergencyContactNo.Text;
Models.MEmployees me = new Models.MEmployees();
me.DesignationId = "1";
me.FirstName = FirstName;
me.LastName = LastName;
me.DateOfBirth = Dob;
me.Address = Address;
me.City = City;
me.HomePhone = HomePhone;
me.CellNo = CellNo;
me.Email = Email;
me.EmergencyContactNo = EmergencyContactNo;
me.WareHouseId = WareHouseId;
Classes.CEmployees ce = new Classes.CEmployees();
if (ce.Save(me) < 0)
{
ShowFailMessage();
}
else
{
ShowSuccessMessage();
ClearTextBoxes(Page);
}
}
}
else
{
ShowErrorModal("Cannot Save, No Warehouse associated with current user");
}
}
