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