public void insert(string ProductName, double Rate, int Quantity, double Arise, int CatalogeId, string Description)
{
sta.ProductName = ProductName;
sta.Rate = Convert.ToDecimal(Rate);
sta.Quantity = Convert.ToInt32(Quantity);
sta.CatalogeId = Convert.ToInt32(CatalogeId);
sta.Arise = Convert.ToDecimal(Arise);
sta.Description = Description;
dct.Stationeries.InsertOnSubmit(sta);
dct.SubmitChanges();
}
public void AddConfig(string mailname, string mailnetwork, string password, string ports, string type, DateTime builddate, string description)
{
Config c = new Config();
c.MailName = mailname;
c.MailNetwork = mailnetwork;
c.Password = password;
c.Ports = ports;
c.Type = type;
c.BuildDate = builddate;
c.Description = description;
dcs.Configs.InsertOnSubmit(c);
dcs.SubmitChanges();
}
public void update(int requestid, string rname, string st, DateTime dd, DateTime da, bool acc, string rc, string en, string dt, int ctid)
{
Request rq = dc.Requests.Where(r => r.RequestId == requestid).ToList().First();
rq.RequestName = rname;
rq.State = st;
rq.DateDispatch = dd;
rq.DateApprove = da;
rq.Accept = acc;
rq.RequestContent = rc;
rq.EmployeeNumber = en;
rq.Description = dt;
rq.CatalogRQId = ctid;
dc.SubmitChanges();
}
public void changepass(string user, string pass)
{
Employee em = dcsd.Employees.Where(p => p.EmployeeNumber == user).FirstOrDefault();
em.Password = pass;
dcsd.SubmitChanges();
}
public void UDate(int role, string rname, double Amount)
{
Role r = dct.Roles.Where(r2 => r2.RoleId == role).ToList().First();
r.Amount = Convert.ToDecimal(Amount);
r.RoleName = rname;
dct.SubmitChanges();
}
public void ThemTK(string EmployeeNumber, string fullname, DateTime datebuild, DateTime dateBirth, string email, string address, string phone, string images, int roleid, string password, string RegistrationNumber)
{
Employee e = new Employee();
e.EmployeeNumber = EmployeeNumber;
e.FullName = fullname;
e.DateBuild = datebuild;
e.DateBirth = dateBirth;
e.Email = email;
e.Address = address;
e.Phone = phone;
e.Images = images;
e.RoleId = roleid;
e.Password = password;
e.RegistrationNumber = RegistrationNumber;
dcs.Employees.InsertOnSubmit(e);
dcs.SubmitChanges();
}
public ActionResult DeleteStationery(int id)
{
try
{
tsa = dct.Stationeries.Where(s => s.ProductId == id).First();
dct.Stationeries.DeleteOnSubmit(tsa);
dct.SubmitChanges();
Session.Remove("kt");
return(RedirectToAction("Statioery"));
}
catch
{
Session["kt"] = "<div class='response-msg error ui-corner-all'><span>Error message</span>Message:This product can not be removed</div>";
return(RedirectToAction("Statioery"));
}
}
//them gio hang
public void inserdata(Request rs)
{
dc.Requests.InsertOnSubmit(rs);
dc.SubmitChanges();
}
public void add(string CatalogeName)
{
ct.CatalogeName = CatalogeName;
dct.Cataloges.InsertOnSubmit(ct);
dct.SubmitChanges();
}
public void add(string CatalogRQName)
{
rq.CatalogRQName = CatalogRQName;
dct.CatalogeRQs.InsertOnSubmit(rq);
dct.SubmitChanges();
}
