public static string Update(int ID, string AgentName, string AgentDescription, string AgentAddress, string AgentPhone, string AgentEmail, string AgentLeader,
bool IsHidden, DateTime ModifiedDate, string ModifiedBy, string AgentFacebook)
{
using (var dbe = new inventorymanagementEntities())
{
tbl_Agent ui = dbe.tbl_Agent.Where(a => a.ID == ID).SingleOrDefault();
if (ui != null)
{
ui.AgentName = AgentName;
ui.AgentDescription = AgentDescription;
ui.AgentAddress = AgentAddress;
ui.AgentPhone = AgentPhone;
ui.AgentEmail = AgentEmail;
ui.AgentFacebook = AgentFacebook;
ui.AgentLeader = AgentLeader;
ui.IsHidden = IsHidden;
ui.ModifiedBy = ModifiedBy;
ui.ModifiedDate = ModifiedDate;
int kq = dbe.SaveChanges();
return(kq.ToString());
}
else
{
return(null);
}
}
}
public static tbl_Agent GetByAPICodeID(string AgentAPIID, string AgentAPICode)
{
using (var dbe = new inventorymanagementEntities())
{
tbl_Agent ai = dbe.tbl_Agent.Where(a => a.AgentAPIID == AgentAPIID && a.AgentAPICode == AgentAPICode).SingleOrDefault();
if (ai != null)
{
return(ai);
}
else
{
return(null);
}
}
}
public static tbl_Agent GetByID(int ID)
{
using (var dbe = new inventorymanagementEntities())
{
tbl_Agent ai = dbe.tbl_Agent.Where(a => a.ID == ID).SingleOrDefault();
if (ai != null)
{
return(ai);
}
else
{
return(null);
}
}
}
public static string Insert(string AgentName, string AgentDescription, string AgentAddress, string AgentPhone, string AgentEmail, string AgentLeader,
bool IsHidden, string AgentAPIID, string AgentAPICode, DateTime CreatedDate, string CreatedBy, string AgentFacebook)
{
using (var dbe = new inventorymanagementEntities())
{
tbl_Agent ui = new tbl_Agent();
ui.AgentName = AgentName;
ui.AgentDescription = AgentDescription;
ui.AgentAddress = AgentAddress;
ui.AgentPhone = AgentPhone;
ui.AgentFacebook = AgentFacebook;
ui.AgentEmail = AgentEmail;
ui.AgentLeader = AgentLeader;
ui.IsHidden = IsHidden;
ui.AgentAPIID = AgentAPIID;
ui.AgentAPICode = AgentAPICode;
ui.CreatedDate = CreatedDate;
ui.CreatedBy = CreatedBy;
dbe.tbl_Agent.Add(ui);
int kq = dbe.SaveChanges();
return(kq.ToString());
}
}
