public static int Subsun(int iid, string maincat, string subcat) { ckdatabase db = new ckdatabase(); int result = db.tasks_installation.Where(t => t.installation_number == iid && t.task.task_main_cat == maincat && t.task.task_sub_cat == subcat).Count(); return(result); }
public static string convert(int tasknum) { ckdatabase db = new ckdatabase(); string result = db.tasks.Where(x => x.task_number == tasknum).Select(w => w.task_name).First(); db = null; return(result); }
public ActionResult Add(FormCollection form) { try { rate target = new rate(); //get property TryUpdateModel(target, new string[] { "rate_name", "rate_measurement", "amount", "start_date", "end_date", "deleted" }, form.ToValueProvider()); target.deleted = false; target.end_date = new DateTime(2222, 1, 1); ViewBag.Error = null; // Update Previous Cost Detail string query = ""; int PrevId = 0; DateTime dt1 = target.start_date; dt1 = dt1.AddDays(-1); if (db.rates.Any(p => p.rate_name == target.rate_name && p.deleted == false)) { ViewBag.m = "Duplicate Entry."; return(View()); } else { var ctx1 = new ckdatabase(); query = "Select Top 1 Rate_number from rates where rate_name ='" + target.rate_name + "' and start_date<'" + target.start_date + "' and deleted=0 order by start_date Desc"; PrevId = ctx1.Database.SqlQuery <int>(query).FirstOrDefault <int>(); if (PrevId != 0) { query = "Update rates set end_date='" + dt1 + "' where tax_number='" + PrevId.ToString() + "'"; var ctx2 = new ckdatabase(); int noOfRowUpdated = ctx2.Database.ExecuteSqlCommand(query); } db.rates.Add(target); db.SaveChanges(); ViewBag.m = "The Labor Cost was successfully created " + "on " + System.DateTime.Now; string search = null; return(RedirectToAction("ListLaborCost", new { search, msg = ViewBag.m })); } } catch (Exception e) { ViewBag.m = "The Labor was not created " + e.Message; return(View()); } }
public ActionResult Update(int id, FormCollection form) { try { tax target = new tax(); //get property TryUpdateModel(target, new string[] { "tax_anme", "tax_value", "city", "state", "county", "zipcode", "start_date", "end_date", "deleted", "in_city" }, form.ToValueProvider()); target.tax_anme = "State Tax"; target.city = ""; target.county = ""; target.zipcode = ""; target.deleted = false; target.in_city = false; target.end_date = new DateTime(2222, 1, 1); ViewBag.Error = null; // Update Previous Tax Detail string query = ""; int PrevId = 0; DateTime dt1 = target.start_date; dt1 = dt1.AddDays(-1); var ctx1 = new ckdatabase(); query = "Select Top 1 tax_number from taxes where tax_anme = 'State Tax' and state = '" + target.state + "' and start_date<'" + target.start_date + "' and deleted=0 order by start_date Desc"; PrevId = ctx1.Database.SqlQuery <int>(query).FirstOrDefault <int>(); if (PrevId != 0) { query = "Update taxes set end_date='" + dt1 + "' where tax_anme='State Tax' and state='" + target.state + "'"; query = query + " and tax_number='" + PrevId.ToString() + "'"; var ctx2 = new ckdatabase(); int noOfRowUpdated = ctx2.Database.ExecuteSqlCommand(query); } db.taxes.Add(target); db.SaveChanges(); ViewBag.m = "The State Tax was successfully created " + "on " + System.DateTime.Now; //return View(target); string search = null; return(RedirectToAction("ListTax", new { search, msg = ViewBag.m })); } catch (Exception e) { ViewBag.m = "The State Tax was not created " + e.Message; return(View()); } }
public ActionResult Edit(int id, FormCollection fo) { try { List <tax> tax_list = db.taxes.Where(d => d.tax_number == id).ToList(); ViewBag.Employeeslist = tax_list; tax target = tax_list[0]; TryUpdateModel(target, new string[] { "tax_anme", "tax_value", "city", "state", "county", "zipcode", "start_date", "end_date", "deleted", "in_city" }, fo.ToValueProvider()); target.tax_anme = "State Tax"; target.city = ""; target.county = ""; target.zipcode = ""; target.deleted = false; target.in_city = false; ViewBag.Error = null; // Update Previous Tax Detail string query = ""; int PrevId = 0; DateTime dt1 = (DateTime)target.start_date; DateTime dt2 = new DateTime(2222, 1, 1);; dt1 = dt1.AddDays(-1); var ctx1 = new ckdatabase(); query = "Select Top 1 tax_number from taxes where tax_anme = 'State Tax' and state = '" + target.state + "' and start_date<'" + target.start_date + "' and deleted=0 and tax_number<> '" + id.ToString() + "' order by start_date Desc"; PrevId = ctx1.Database.SqlQuery <int>(query).FirstOrDefault <int>(); if (PrevId != 0) { query = "Update taxes set end_date='" + dt1 + "' where tax_anme='State Tax' and state='" + target.state + "'"; query = query + " and tax_number='" + PrevId.ToString() + "'"; var ctx2 = new ckdatabase(); int noOfRowUpdated = ctx2.Database.ExecuteSqlCommand(query); } db.SaveChanges(); ViewBag.m = " The state tax was successfully updated " + " on " + System.DateTime.Now; //return View(target); string search = null; return(RedirectToAction("ListTax", new { search, msg = ViewBag.m })); } catch (Exception e) { ViewBag.m = "Something went wrong ... " + e.Message; return(View()); } }
public ActionResult Edit(int id, FormCollection form) { try { List <rate> rate_list = db.rates.Where(d => d.rate_number == id).ToList(); ViewBag.Employeeslist = rate_list; rate target = rate_list[0]; TryUpdateModel(target, new string[] { "rate_name", "rate_measurement", "amount", "start_date", "end_date", "deleted" }, form.ToValueProvider()); target.deleted = false; target.end_date = new DateTime(2222, 1, 1); ViewBag.Error = null; // Update Previous Labor Cost Detail string query = ""; int PrevId = 0; DateTime dt1 = target.start_date; DateTime dt2 = new DateTime(2222, 1, 1);; dt1 = dt1.AddDays(-1); var ctx1 = new ckdatabase(); query = "Select Top 1 rate_number from rates where deleted=0 and rate_number<> '" + id.ToString() + "' order by start_date Desc"; PrevId = ctx1.Database.SqlQuery <int>(query).FirstOrDefault <int>(); if (PrevId != 0) { query = "Update rates set end_date='" + dt1 + "' where rate_number='" + PrevId.ToString() + "'"; var ctx2 = new ckdatabase(); int noOfRowUpdated = ctx2.Database.ExecuteSqlCommand(query); } db.SaveChanges(); ViewBag.m = " The Labor Cost was successfully updated " + " on " + System.DateTime.Now; //return View(target); string search = null; return(RedirectToAction("ListLaborCost", new { search, msg = ViewBag.m })); } catch (Exception e) { ViewBag.m = "Something went wrong ... " + e.Message; return(View()); } }