public ActionResult save_supplier(string suppId, string suppName, string suppAddress, string suppCity, string suppPhone, string suppDesc, int mode = 0) { using (var db = new dbsmsEntities()) { if (String.IsNullOrEmpty(suppId)) { supplier data = new supplier(); data.name = suppName; data.phone = suppPhone; data.city = suppCity; data.address = suppAddress; data.description = suppDesc; data.status = 1; db.suppliers.Add(data); } else { supplier data = db.suppliers.Find(Convert.ToInt64(suppId)); data.name = suppName; data.address = suppAddress; data.phone = suppPhone; data.city = suppCity; data.description = suppDesc; } db.SaveChanges(); } TempData["success"] = "Your data has been saved."; if (mode != 0) { return(null); } return(RedirectToAction("Master_Supplier", "Master")); }
public static Boolean has_privilege(String username, String action, String table) { using (var db = new dbsmsEntities()) { Boolean result = false; try { user userNow = (from u in db.users where u.username == username select u).First(); userNow.roles.ToList().ForEach(x => { foreach (privilege item in x.privileges) { if (item.action.Contains(action) && item.tablename.Replace("_", "") == table.Replace("_", "")) { result = true; } } }); } catch { } return(result); } }
public string save_user(string userId, string userName, string userUserName, string userDesc) { string userPass = ""; using (var db = new dbsmsEntities()) { if (db.users.Select(x => x.username).Contains(userUserName)) { return("0"); } if (String.IsNullOrEmpty(userId)) { user data = new user(); data.name = userName; data.username = userUserName; userPass = userUserName + "123"; data.password = MD5.Hash(userPass); data.description = userDesc; data.status = 1; db.users.Add(data); } else { user data = db.users.Find(Convert.ToInt64(userId)); data.name = userName; data.username = userUserName; data.password = MD5.Hash(userPass); data.description = userDesc; } db.SaveChanges(); } return("1"); }
//data: { pdate: pdate, ptype: ptype, pnote: pnote, pinvid: pinvid}, public String save_it(String pdate, String ptype, Int64 pinvid, String pnote) { try { DateTime datenow = Convert.ToDateTime(pdate); using (var db = new dbsmsEntities()) { salespayment newdata = new salespayment(); newdata.date = datenow; newdata.description = ""; newdata.salesinvoiceid = pinvid; newdata.to = db.hsalesinvoices.Find(pinvid).customer.name + "\n" + db.hsalesinvoices.Find(pinvid).customer.address + "\n" + db.hsalesinvoices.Find(pinvid).customer.city + "\n" + db.hsalesinvoices.Find(pinvid).customer.phone; newdata.projectid = Convert.ToInt64(Session["project"]); newdata.type = ptype; newdata.note = pnote; newdata.total = db.hsalesinvoices.Find(pinvid).grandtotal; newdata.number = db.hsalesinvoices.Find(pinvid).number; db.hsalesinvoices.Find(pinvid).status = 1; db.salespayments.Add(newdata); db.projects.Find(Convert.ToInt64(Session["project"])).status1.salespayment = 1; db.SaveChanges(); return(GlobalFunction.get_max_id("salespayment").ToString()); } } catch (Exception e) { return("fail"); } }
public ActionResult save_customer(string custId, string custName, string custAddress, string custCity, string custPhone, string custDesc, int mode = 0) { using (var db = new dbsmsEntities()) { if (String.IsNullOrEmpty(custId)) { customer data = new customer(); data.name = custName; data.phone = custPhone; data.city = custCity; data.address = custAddress; data.description = custDesc; data.status = 1; db.customers.Add(data); } else { customer data = db.customers.Find(Convert.ToInt64(custId)); data.name = custName; data.address = custAddress; data.phone = custPhone; data.city = custCity; data.description = custDesc; } db.SaveChanges(); } TempData["success"] = "Your data has been saved."; if (mode != 0) { return(null); } return(RedirectToAction("Master_Customer", "Master")); }
//data: { pdate: pdate, ptype: ptype, pnote: pnote, pinvid: pinvid}, public String save_it(String pdate, String ptype, Int64 pinvid, String pnote) { try { DateTime datenow = Convert.ToDateTime(pdate); using (var db = new dbsmsEntities()) { purchasepayment newdata = new purchasepayment(); newdata.date = datenow; newdata.description = ""; newdata.purchaseinvoiceid = pinvid; newdata.supplierid = db.hpurchaseinvoices.Find(pinvid).supplierid; newdata.projectid = Convert.ToInt64(Session["project"]); newdata.type = ptype; newdata.note = pnote; newdata.total = db.hpurchaseinvoices.Find(pinvid).grandtotal; newdata.number = db.hpurchaseinvoices.Find(pinvid).number; db.hpurchaseinvoices.Find(pinvid).status = 1; db.purchasepayments.Add(newdata); db.projects.Find(Convert.ToInt64(Session["project"])).status1.purchasepayment = 1; db.SaveChanges(); return(GlobalFunction.get_max_id("purchasepayment").ToString()); } } catch (Exception e) { return("fail"); } }
public static Boolean is_allowed(long projectId, String destination) { using (var db = new dbsmsEntities()) { status projStatus = (from p in db.projects where p.id == projectId select p.status1).First(); if (destination == "salespayment" && projStatus.salesinvoice == 1) { return(true); } else if (destination == "salesinvoice" && projStatus.salesorder == 1) { return(true); } else if (destination == "deliveryorder" && projStatus.receiveitem == 1) { return(true); } else if (destination == "purchasepayment" && projStatus.purchaseinvoice == 1) { return(true); } else if (destination == "purchaseinvoice" && projStatus.purchaseorder == 1) { return(true); } else if (destination == "receiveitem" && projStatus.purchaseorder == 1) { return(true); } else if (destination == "purchaseorder" && projStatus.salesorder == 1) { return(true); } else if (destination == "salesorder" && projStatus.penawaran == 1) { return(true); } else if (destination == "penawaran" && projStatus.findprices == 1) { return(true); } else if (destination == "findprices" && projStatus.rfq == 1) { return(true); } else if (destination == "suratjalan" && projStatus.receiveitem == 1) { return(true); } else { return(false); } } }
public String get_unpaid(Int64 projid) { try { using (var db = new dbsmsEntities()) { List <hpurchaseinvoice> hpi = db.hpurchaseinvoices.Where(x => x.projectid == projid && x.status != 1).ToList(); List <hsalesinvoice> hsi = db.hsalesinvoices.Where(x => x.projectid == projid && x.status != 1).ToList(); String hpirow = "<table class='table table-hover table-bordered'>" + "<caption class='text-center text-bold'>Unpaid Purchase Invoice</caption><thead>" + "<tr>" + "<th class='col-md-3 text-center'>Invoice Number</th>" + "<th class='col-md-3 text-center'>Supplier Name</th>" + "</tr></thead><tbody>"; foreach (hpurchaseinvoice item in hpi) { hpirow += "<tr>" + "<td><a href='" + Url.Action("move", "Project") + "?controller=PurchasePayment&projid=" + projid + "&id=0'>" + item.number + "</a></td>" + "<td>" + item.supplier.name + "</td>" + "</tr>"; } hpirow += "</tbody></table>"; if (hpi.Count <= 0) { hpirow = "All purchase invoices have been paid"; } String hsirow = "<table class='table table-hover table-bordered'>" + "<caption class='text-center text-bold'>Unpaid Sales Invoice</caption><thead>" + "<tr>" + "<th class='col-md-6 text-center'>Invoice Number</th>" + "<th class='col-md-6 text-center'>Customer Name</th>" + "</tr></thead><tbody>"; foreach (hsalesinvoice item in hsi) { hsirow += "<tr>" + "<td><a href='" + Url.Action("move", "Project") + "?controller=SalesPayment&projid=" + projid + "&id=0'>" + item.number + "</a></td>" + "<td>" + item.customer.name + "</td>" + "</tr>"; } hsirow += "</tbody></table>"; if (hsi.Count <= 0) { hsirow = "All sales invoices have been paid"; } return("<div class='col-md-5'>" + hpirow + "<br/>" + hsirow + "</div>"); } } catch { return("undefined"); } }
public ActionResult FinishProject() { using (var db = new dbsmsEntities()) { Int64 id = Convert.ToInt64(Session["project"]); db.projects.Find(id).status = 1; db.SaveChanges(); } return(Redirect(Url.Action("Index", "Home"))); }
public String reset_pass(String userid) { using (var db = new dbsmsEntities()) { user data = db.users.Find(Convert.ToInt64(userid)); data.password = MD5.Hash(data.username + "123"); db.SaveChanges(); } return("reset ke username + 123"); }
public static List <String> getId(Int64 projectId, byte value) { List <String> elements = new List <string>(); using (var db = new dbsmsEntities()) { status status_ = db.projects.Find(projectId).status1; if (status_.rfq == value) { elements.Add("rfq"); } if (status_.findprices == value) { elements.Add("findprices"); } if (status_.penawaran == value) { elements.Add("penawaran"); } if (status_.salesorder == value) { elements.Add("salesorder"); } if (status_.purchaseorder == value) { elements.Add("purchaseorder"); } if (status_.receiveitem == value) { elements.Add("receiveitem"); } if (status_.purchaseinvoice == value) { elements.Add("purchaseinvoice"); } if (status_.purchasepayment == value) { elements.Add("purchasepayment"); } if (status_.suratjalan == value) { elements.Add("suratjalan"); } if (status_.salesinvoice == value) { elements.Add("salesinvoice"); } if (status_.salespayment == value) { elements.Add("salespayment"); } } return(elements); }
public String save_all(String number, String date, long customerid, string to, string description, String projectName, string detail) { try { using (var db = new dbsmsEntities()) { status s = new status(); project p = new project(); p.status1 = s; p.name = projectName; p.status = 0; p.description = ""; db.projects.Add(p); db.SaveChanges(); Session["project"] = db.projects.Select(x => x.id).Max(); } DateTime datenow = Convert.ToDateTime(date); using (var db = new dbsmsEntities()) { hrfq newdata = new hrfq(); newdata.number = number; newdata.date = datenow; newdata.customerid = customerid; newdata.to = to; newdata.description = description; newdata.projectid = Convert.ToInt64(Session["project"]); db.hrfqs.Add(newdata); String[] res = detail.Split('ѥ'); for (int i = 0; i < res.Length - 1; i++) { String[] result = res[i].Split('Ё'); drfq data = new drfq(); data.itemcategoryid = Convert.ToInt64(result[0]); data.itemdescription = result[1]; data.qty = Convert.ToInt32(result[2]); data.unitprice = Convert.ToInt32(result[3]); data.subtotal = data.qty * data.unitprice; db.drfqs.Add(data); } db.SaveChanges(); using (var db1 = new dbsmsEntities()) { db1.hrfqs.Find(GlobalFunction.get_max_id("hrfq")).project.status1.rfq = 1; db1.hrfqs.Find(GlobalFunction.get_max_id("hrfq")).project.customerid = customerid; db1.SaveChanges(); return("success"); } } } catch (Exception e) { return("fail"); } }
public ActionResult delete_role(string roleId) { using (var db = new dbsmsEntities()) { role data = db.roles.Find(Convert.ToInt64(roleId)); db.users.ToList().ForEach(x => x.roles.Remove(data)); db.privileges.ToList().ForEach(x => x.roles.Remove(data)); db.roles.Remove(data); db.SaveChanges(); } TempData["success"] = "Your data has been deleted."; return(RedirectToAction("Index", "Role")); }
public String getRole(string userid) { using (var db = new dbsmsEntities()) { String result = ""; List <role> data = db.users.Find(Convert.ToInt64(userid)).roles.ToList(); foreach (role item in data) { result += item.id + "|"; } return(result); } }
//data: { pino: pino, pidate: pidate, poid: poid, desc: desc, detail: detail, disc:disc }, public String save_it(String pino, String pidate, Int64 poid, Int64 disc, String desc, String detail) { try { DateTime datenow = Convert.ToDateTime(pidate); using (var db = new dbsmsEntities()) { hpurchaseinvoice newdata = new hpurchaseinvoice(); newdata.date = datenow; newdata.description = desc; newdata.poid = poid; newdata.supplierid = db.hpoes.Find(poid).supplierid; newdata.projectid = Convert.ToInt64(Session["project"]); newdata.terms = "C.O.D"; newdata.number = pino; db.hpurchaseinvoices.Add(newdata); Int64 total = 0; String[] res = detail.Split('ѥ'); for (int i = 0; i < res.Length - 1; i++) { String[] result = res[i].Split('Ё'); dpurchaseinvoice data = new dpurchaseinvoice(); //detail += itemcatid + "Ё" + itemdescription + "Ё" + qty + "Ё" + unitprice; data.itemcategoryid = Convert.ToInt64(result[0]); data.itemdescription = result[1]; data.qty = Convert.ToInt32(result[2]); data.unitprice = Convert.ToInt32(result[3]); data.subtotal = data.qty * data.unitprice; total += data.subtotal; //data.penawaranid = GlobalFunction.get_max_id("hpenawaran"); db.dpurchaseinvoices.Add(data); } total -= db.hpoes.Find(poid).dp; newdata.total = total; newdata.diskon = disc; newdata.grandtotal = newdata.total - newdata.diskon; db.SaveChanges(); using (var db1 = new dbsmsEntities()) { db1.projects.Find(Convert.ToInt64(Session["project"])).status1.purchaseinvoice = 1; db1.SaveChanges(); return("success"); } } } catch (Exception e) { return("fail"); } }
public ActionResult delete_category(string catId) { using (var db = new dbsmsEntities()) { if (!String.IsNullOrEmpty(catId)) { item_category data = db.item_category.Find(Convert.ToInt64(catId)); data.status = 0; } db.SaveChanges(); } TempData["success"] = "Your data has been deleted."; return(RedirectToAction("Master_Kategori", "Master")); }
public ActionResult delete_user(string userId) { using (var db = new dbsmsEntities()) { if (!String.IsNullOrEmpty(userId)) { user data = db.users.Find(Convert.ToInt64(userId)); data.status = 0; } db.SaveChanges(); } TempData["success"] = "Your data has been deleted."; return(RedirectToAction("Master_User", "Master")); }
public String edit_desc(Int64 projid, String desc) { try { using (var db = new dbsmsEntities()) { db.projects.Find(projid).description = desc; db.SaveChanges(); } return("success"); } catch { return("fail"); } }
public ActionResult save_role(String param, String userid) { using (var db = new dbsmsEntities()) { user data = db.users.Find(Convert.ToInt64(userid)); db.roles.ToList().ForEach(x => x.users.Remove(data)); foreach (String item in param.Split('|')) { if (!String.IsNullOrEmpty(item)) { role rol = db.roles.Find(Convert.ToInt64(item)); data.roles.Add(rol); } } db.SaveChanges(); } return(RedirectToAction("Master_User", "Master")); }
public String delete_it(Int64 id) { try { using (var db = new dbsmsEntities()) { salespayment data = db.salespayments.Find(id); data.hsalesinvoice.status = 0; db.salespayments.Remove(data); db.SaveChanges(); return("success"); } } catch { return("fail"); } }
public ActionResult History() { if (!GlobalFunction.has_privilege(Session["user"].ToString(), "select", "purchase_order")) { TempData["back_url"] = Request.UrlReferrer.ToString(); return(Redirect(Url.Action("error403", "Error"))); } using (var db = new dbsmsEntities()) { Int64 id = Convert.ToInt64(Request.QueryString["id"]); Byte status = db.hpoes.Find(id).status; if (status == 0) { return(Redirect(Url.Action("Transaksi", "PurchaseOrder") + "?id=" + id)); } } return(View()); }
public String save_all(string detail) { try { using (var db = new dbsmsEntities()) { Int64 projid = Convert.ToInt64(Session["project"]); List <findprice> deleted = db.projects.Find(projid).findprices.ToList(); if (deleted.Count > 0) { db.findprices.RemoveRange(deleted); } db.SaveChanges(); String[] res = detail.Split('ѥ'); for (int i = 0; i < res.Length - 1; i++) { String[] result = res[i].Split('Ё'); findprice data = new findprice(); data.supplierid = Convert.ToInt64(result[0]); data.address = ""; data.itemcategoryid = Convert.ToInt64(result[1]); data.itemdescription = result[2]; data.qty = Convert.ToInt64(result[3]); data.unitprice = Convert.ToInt64(result[4]); data.timeneeded = Convert.ToInt64(result[5]); data.description = result[6]; data.status = 1; data.projectid = Convert.ToInt64(Session["project"]); db.findprices.Add(data); } db.SaveChanges(); using (var db1 = new dbsmsEntities()) { db1.findprices.Find(GlobalFunction.get_max_id("findprices")).project.status1.findprices = 1; db1.SaveChanges(); return("success"); } } } catch (Exception e) { return("fail"); } }
public String delete_it(Int64 id) { try { using (var db = new dbsmsEntities()) { hreceiveitem data = db.hreceiveitems.Find(id); List <dreceiveitem> ddata = data.dreceiveitems.ToList(); db.dreceiveitems.RemoveRange(ddata); db.hreceiveitems.Remove(data); db.SaveChanges(); return("success"); } } catch { return("fail"); } }
public String delete_it(Int64 id) { try { using (var db = new dbsmsEntities()) { hsalesinvoice data = db.hsalesinvoices.Find(id); List <dsalesinvoice> ddata = data.dsalesinvoices.ToList(); db.dsalesinvoices.RemoveRange(ddata); db.hsalesinvoices.Remove(data); db.SaveChanges(); return("success"); } } catch { return("fail"); } }
public ActionResult Login(String username, String password) { using (var db = new dbsmsEntities()) { password = MD5.Hash(password); try { user usr = (from u in db.users where u.username == username && u.password == password select u).First(); Session["user"] = usr.username; return(RedirectToAction("Index", "Home")); } catch (Exception e) { TempData["message"] = "Invalid Username or Password"; } return(RedirectToAction("Index", "Login")); } }
// GET: RFQ public ActionResult Index() { if (!GlobalFunction.has_privilege(Session["user"].ToString(), "select", "rfq")) { TempData["back_url"] = Request.UrlReferrer.ToString(); return(Redirect(Url.Action("error403", "Error"))); } //return Redirect(Request.UrlReferrer.ToString()); using (var db = new dbsmsEntities()) { if (Session["project"] != null && db.projects.Find(Session["project"]).status1.rfq == 1) { return(View("History")); } else { return(View()); } } }
public String getPrivileges(String roleId) { try { using (var db = new dbsmsEntities()) { role thisRole = db.roles.Find(Convert.ToInt64(roleId)); String privileges = ""; foreach (var item in thisRole.privileges) { privileges = privileges + item.action + item.tablename + "-"; } return(privileges); } } catch (Exception ex) { throw ex; } }
public string change_password(string oldPassword, string newPassword) { using (var db = new dbsmsEntities()) { try { string pass = MD5.Hash(oldPassword); string username = Session["user"].ToString(); user user_ = (from u in db.users where u.password == pass && u.username == username select u).First(); user_.password = MD5.Hash(newPassword); db.SaveChanges(); return("1"); } catch (System.Exception e) { return("0"); } } }
public String save_it(String sjdate, String shipto, String desc, String detail) { try { DateTime datenow = Convert.ToDateTime(sjdate); using (var db = new dbsmsEntities()) { hsuratjalan newdata = new hsuratjalan(); newdata.date = datenow; newdata.description = desc; newdata.to = shipto; newdata.projectid = Convert.ToInt64(Session["project"]); newdata.number = GlobalFunction.generate_code("SJ"); db.hsuratjalans.Add(newdata); String[] res = detail.Split('ѥ'); for (int i = 0; i < res.Length - 1; i++) { String[] result = res[i].Split('Ё'); dsuratjalan data = new dsuratjalan(); //detail += itemcatid + "Ё" + itemdescription + "Ё" + qty; data.itemcategoryid = Convert.ToInt64(result[0]); data.itemdescription = result[1]; data.qty = Convert.ToInt32(result[2]); //data.penawaranid = GlobalFunction.get_max_id("hpenawaran"); db.dsuratjalans.Add(data); } db.SaveChanges(); using (var db1 = new dbsmsEntities()) { db1.projects.Find(Convert.ToInt64(Session["project"])).status1.suratjalan = 1; db1.SaveChanges(); return("success"); } } } catch (Exception e) { return("fail"); } }
public ActionResult save_role(string roleId, string roleName, string roleDesc) { using (var db = new dbsmsEntities()) { if (String.IsNullOrEmpty(roleId)) { role data = new role(); data.name = roleName; data.description = roleDesc; db.roles.Add(data); } else { role data = db.roles.Find(Convert.ToInt64(roleId)); data.name = roleName; data.description = roleDesc; } db.SaveChanges(); } TempData["success"] = "Your data has been saved."; return(RedirectToAction("Index", "Role")); }