//linq query used to update employee details of (ImSS_Master_Emp_List)
public List <ImSS_Master_Emp_List> UpdateEmployee(ImSS_Master_Emp_List empl)
{
try
{
using (var context = new Billing_StagingEntities1())
{
ImSS_Master_Emp_List UpdateEmployee = (from c in context.ImSS_Master_Emp_List where c.ID == empl.ID select c).FirstOrDefault();
UpdateEmployee.Emp_Number = empl.Emp_Number;
UpdateEmployee.Emp_Name = empl.Emp_Name;
UpdateEmployee.DOJ = empl.DOJ;
UpdateEmployee.Previous_Exp = empl.Previous_Exp;
UpdateEmployee.ImSS_Exp = empl.ImSS_Exp;
UpdateEmployee.Total_Exp = empl.Total_Exp;
UpdateEmployee.Domain = empl.Domain;
UpdateEmployee.Business_Unit = empl.Business_Unit;
UpdateEmployee.Reporting = empl.Reporting;
UpdateEmployee.Primary_Skills = empl.Primary_Skills;
UpdateEmployee.Secondary_Skills = empl.Secondary_Skills;
UpdateEmployee.Category = empl.Category;
UpdateEmployee.Status = empl.Status;
UpdateEmployee.Mobile_Number = empl.Mobile_Number;
UpdateEmployee.Replaced_by = empl.Replaced_by;
UpdateEmployee.Relived_Date = empl.Relived_Date;
context.SaveChanges();
var val = (from e in context.ImSS_Emp_Details
where e.Employee_ID == empl.Emp_Number && e.Manager_ID == empl.Reporting &&
e.End_Date == null
select e).Count();
if (val == 0)
{
ImSS_Emp_Details Empdet = (from c in context.ImSS_Emp_Details where c.Employee_ID == empl.Emp_Number && c.End_Date == null select c).FirstOrDefault();
Empdet.End_Date = DateTime.Now;
ImSS_Emp_Details lst = new ImSS_Emp_Details();
lst.Start_Date = DateTime.Now;
lst.Employee_ID = empl.Emp_Number;
lst.Manager_ID = empl.Reporting;
context.ImSS_Emp_Details.Add(lst);
context.SaveChanges();
}
return((from a in context.ImSS_Master_Emp_List select a).ToList());
}
}
catch (Exception e)
{
throw e;
}
}
//linq query used to update po details of (ImSS_Master_PO)
public List <ImSS_Master_PO> UpdatePO(ImSS_Master_PO po)
{
try
{
using (var context = new Billing_StagingEntities1())
{
ImSS_Master_PO UpdatePo = (from c in context.ImSS_Master_PO where c.ID == po.ID select c).FirstOrDefault();
UpdatePo.Client_Name = po.Client_Name;
UpdatePo.Project_Name = po.Project_Name;
UpdatePo.PO_Number = po.PO_Number;
UpdatePo.Point_Of_Contact = po.Point_Of_Contact;
UpdatePo.Mode_Of_Payment = po.Mode_Of_Payment;
UpdatePo.Currency = po.Currency;
UpdatePo.PO_StartDate = po.PO_StartDate;
UpdatePo.PO_EndDate = po.PO_EndDate;
UpdatePo.PO_Initial_Amount = po.PO_Initial_Amount;
UpdatePo.PO_Duration = po.PO_Duration;
UpdatePo.PO_Renewed_Amount = po.PO_Renewed_Amount;
UpdatePo.PO_Renewed_Date = po.PO_Renewed_Date;
UpdatePo.Parent_PO = po.Parent_PO;
UpdatePo.PO_Status = po.PO_Status;
UpdatePo.PO_Total_Amount_INR = po.PO_Total_Amount_INR;
UpdatePo.PO_Close_Date = po.PO_Close_Date;
context.SaveChanges();
return((from a in context.ImSS_Master_PO select a).ToList());
}
}
catch (Exception e)
{
throw e;
}
}
//linq query used to insert employee details into (ImSS_Master_Emp_List)
public ImSS_Master_Client AddCustomer(ImSS_Master_Client Addcust)
{
try
{
using (var context = new Billing_StagingEntities1())
{
ImSS_Cust_Emp_Details lst = new ImSS_Cust_Emp_Details();
lst.Cilent_Start_Date = DateTime.Now;
lst.Emp_Number = Addcust.Emp_Name;
lst.Cilent_ID = Addcust.Client_Name;
if (Addcust.Status == "Active")
{
ImSS_Master_Emp_List UpdateEmployee = (from c in context.ImSS_Master_Emp_List where c.Emp_Name == Addcust.Emp_Name select c).FirstOrDefault();
UpdateEmployee.Status = "Assigned";
}
context.ImSS_Master_Client.Add(Addcust);
context.ImSS_Cust_Emp_Details.Add(lst);
context.SaveChanges();
return(Addcust);
}
}
catch (Exception e)
{
throw e;
}
}
//linq query used to insert POMaster details into (ImSS_Master_Emp_List)
public ImSS_Master_PO AddPOMaster(ImSS_Master_PO po)
{
try
{
using (var context = new Billing_StagingEntities1())
{
context.ImSS_Master_PO.Add(po);
context.SaveChanges();
return(po);
}
}
catch (Exception e)
{
throw e;
}
}
public List <ImSS_Master_Emp_List> UpdateEmployee(ImSS_Master_Emp_List empl)
{
try
{
using (var context = new Billing_StagingEntities1())
{
ImSS_Master_Emp_List UpdateEmployee = (from c in context.ImSS_Master_Emp_List where c.ID == empl.ID select c).FirstOrDefault();
UpdateEmployee.Status = empl.Status;
context.SaveChanges();
return((from a in context.ImSS_Master_Emp_List select a).ToList());
}
}
catch (Exception e)
{
throw e;
}
}
//linq query used to delete PO details of (ImSS_Master_PO)
public List <ImSS_Master_PO> Delete(int?Id)
{
try
{
using (var context = new Billing_StagingEntities1())
{
ImSS_Master_PO DeleteCilent = (from c in context.ImSS_Master_PO where c.ID == Id select c).FirstOrDefault();
if (DeleteCilent != null)
{
context.ImSS_Master_PO.Remove(DeleteCilent);
context.SaveChanges();
}
return((from a in context.ImSS_Master_PO select a).ToList());
}
}
catch (Exception e)
{
throw e;
}
}
//linq query used to insert employee details into (ImSS_Master_Emp_List)
//public ImSS_Master_Emp_List AddEmployee(ImSS_Master_Emp_List Addemp)
//{
// try
// {
// using (var context = new Billing_StagingEntities1())
// {
// ImSS_Emp_Details lst=new ImSS_Emp_Details();
// lst.Start_Date = DateTime.Now;
// lst.Employee_ID = Addemp.Emp_Number;
// lst.Manager_ID = Addemp.Reporting;
// context.ImSS_Master_Emp_List.Add(Addemp);
// context.ImSS_Emp_Details.Add(lst);
// context.SaveChanges();
// return Addemp;
// }
// }
// catch (Exception e)
// {
// throw e;
// }
//}
public ImSS_Master_Emp_List AddEmployee(ImSS_Master_Emp_List Addemp)
{
try
{
using (var context = new Billing_StagingEntities1())
{
ImSS_Emp_Details lst = new ImSS_Emp_Details();
lst.Start_Date = DateTime.Now;
lst.Employee_ID = Addemp.Emp_Number;
lst.Manager_ID = Addemp.Reporting;
context.ImSS_Master_Emp_List.Add(Addemp);
context.ImSS_Emp_Details.Add(lst);
context.SaveChanges();
return(Addemp);
}
}
catch (Exception e)
{
throw e;
}
}
//linq query used to insert employee details into (ImSS_Master_Emp_List)
public ImSS_Master_Client AddCustomer(ImSS_Master_Client Addcust)
{
try
{
using (var context = new Billing_StagingEntities1())
{
ImSS_Cust_Emp_Details lst = new ImSS_Cust_Emp_Details();
lst.Cilent_Start_Date = DateTime.Now;
lst.Emp_Number = Addcust.Emp_Name;
lst.Cilent_ID = Addcust.Client_Name;
context.ImSS_Master_Client.Add(Addcust);
context.ImSS_Cust_Emp_Details.Add(lst);
context.SaveChanges();
return(Addcust);
}
}
catch (Exception e)
{
throw e;
}
}
//linq query used to update employee details of (ImSS_Master_Emp_List)
public List <ImSS_Master_Client> UpdateCilent(ImSS_Master_Client cust)
{
try
{
using (var context = new Billing_StagingEntities1())
{
ImSS_Master_Client UpdateCustomer = (from c in context.ImSS_Master_Client where c.ID == cust.ID select c).FirstOrDefault();
UpdateCustomer.Emp_Name = cust.Emp_Name;
UpdateCustomer.Client_Name = cust.Client_Name;
UpdateCustomer.Email = cust.Email;
UpdateCustomer.Reporting_Manager_at_client_place = cust.Reporting_Manager_at_client_place;
UpdateCustomer.Shadow = cust.Shadow;
UpdateCustomer.Location = cust.Location;
UpdateCustomer.Status = cust.Status;
if (UpdateCustomer.Status == "Active")
{
ImSS_Master_Emp_List UpdateEmployee = (from c in context.ImSS_Master_Emp_List where c.Emp_Name == cust.Emp_Name select c).FirstOrDefault();
UpdateEmployee.Status = "Assigned";
}
else
{
ImSS_Master_Emp_List UpdateEmployee = (from c in context.ImSS_Master_Emp_List where c.Emp_Name == cust.Emp_Name select c).FirstOrDefault();
UpdateEmployee.Status = "Avalible";
ImSS_Cust_Emp_Details Update = (from c in context.ImSS_Cust_Emp_Details where c.Emp_Number == cust.Emp_Name select c).FirstOrDefault();
Update.Cilent_End_Date = DateTime.Now;
}
context.SaveChanges();
return((from a in context.ImSS_Master_Client select a).ToList());
}
}
catch (Exception e)
{
throw e;
}
}
