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"));
}
