public ActionResult Create_Worktype(juggle.Models.tbl_worktype work_type)
{
using (jugglecontext dbcon = new jugglecontext())
{
try
{
tbl_worktype worktype = new tbl_worktype();
worktype.name = work_type.name.Trim();
worktype.color = work_type.color;
var time = Request.Form["multiple"];
worktype.time = time;
worktype.user_id = Convert.ToInt32(Session["User_Id"]);
worktype.created_date = DateTime.Now;
dbcon.tbl_worktype.Add(worktype);
dbcon.SaveChanges();
return(RedirectToAction("Work_type", "Work_type"));
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
return(View(work_type));
}
}
}
public ActionResult Worktype_Edit(juggle.Models.tbl_worktype work_type)
{
try
{
using (jugglecontext dbcon = new jugglecontext())
{
tbl_worktype worktype = new tbl_worktype();
worktype.name = work_type.name.Trim();
worktype.color = work_type.color;
var time = Request.Form["multiple"];
worktype.time = time;
worktype.work_id = work_type.work_id;
worktype.updated_date = DateTime.Now;
worktype.user_id = work_type.user_id;
worktype.created_date = work_type.created_date;
dbcon.Entry(worktype).State = System.Data.Entity.EntityState.Modified;
dbcon.SaveChanges();
return(RedirectToAction("Work_type", "Work_type"));
}
}
catch
{
return(View());
}
}
public ActionResult Worktype_Edit(Int32 work_id) // banse
{
jugglecontext dbcon1 = new jugglecontext();
var content = from p in dbcon1.tbl_worktype
select new { p.work_id, p.name };
var wname = content.ToList().Select(c => new SelectListItem
{
Text = c.name.ToString(),
Value = c.work_id.ToString(),
Selected = (c.work_id == work_id)
}).ToList();
ViewBag.CurrencyList = wname;
try
{
using (jugglecontext dbcon = new jugglecontext())
{
tbl_worktype work_type = dbcon.tbl_worktype.Where(x => x.work_id == work_id).FirstOrDefault();
tbl_worktype prod = new tbl_worktype();
prod.work_id = work_type.work_id;
prod.name = work_type.name;
prod.color = work_type.color;
prod.worktypecat_id = work_type.worktypecat_id;
prod.user_id = work_type.user_id;
prod.created_date = work_type.created_date;
return(View(prod));
}
}
catch (Exception ex)
{
return(View());
}
}
public ActionResult Worktype_delete(Int32 work_id)
{
if (Session["User_Id"] != null)
{
try
{
using (jugglecontext dbcon = new jugglecontext())
{
if (Session["User_Id"] != null)
{
string workid = work_id.ToString();
var employee_detail = (from a in dbcon.tbl_employee_info
where a.emp_qualifiedservicetypes.Contains(workid)
select a).ToList();
for (int i = 0; i < employee_detail.Count; i++)
{
string emp_worktype = employee_detail[i].emp_qualifiedservicetypes.ToString();
emp_worktype = emp_worktype.Replace(workid, "");
SqlConnection connection = new SqlConnection(dbcon.connectionString());
var command = new SqlCommand("[updatedata]", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@client_id", 0);
command.Parameters.AddWithValue("@attribute_id", emp_worktype);
command.Parameters.AddWithValue("@appointment_id", 0);
command.Parameters.AddWithValue("@StatementType", "worktype_data");
command.Parameters.AddWithValue("@emp_id", Convert.ToInt32(employee_detail[i].emp_id));
command.Parameters.AddWithValue("@startdate", 0);
command.Parameters.AddWithValue("@enddate", 0);
command.Parameters.AddWithValue("@StartTime", 0);
command.Parameters.AddWithValue("@endTime", 0);
command.Parameters.AddWithValue("@user_id", Convert.ToInt32(Session["User_Id"]));
connection.Open();
SqlDataReader rdr = command.ExecuteReader();
}
tbl_worktype objEmp = dbcon.tbl_worktype.Find(work_id);
dbcon.tbl_worktype.Remove(objEmp);
dbcon.SaveChanges();
}
return(RedirectToAction("Work_type", "Work_type"));
}
}
catch
{
return(View());
}
}
else
{
return(View("Login", "Account"));
}
}
public void getworktype(Int32 work_id)
{
try
{
using (jugglecontext dbcon = new jugglecontext())
{
tbl_worktype objEmp = dbcon.tbl_worktype.Find(work_id);
}
ViewBag.Countries = new List <string>
{
"India",
"US",
"UK",
"Canada"
};
}
catch (Exception ex)
{
}
}
public ActionResult Worktype_delete(Int32 work_id)
{
try
{
using (jugglecontext dbcon = new jugglecontext())
{
if (Session["User_Id"] != null)
{
tbl_worktype objEmp = dbcon.tbl_worktype.Find(work_id);
dbcon.tbl_worktype.Remove(objEmp);
dbcon.SaveChanges();
}
return(RedirectToAction("Worktype", "Worktype"));
}
}
catch (Exception ex)
{
return(View());
}
}
public ActionResult Worktype_Edit(Int32 work_id) // banse
{
if (Session["User_Id"] != null)
{
jugglecontext dbcon1 = new jugglecontext();
try
{
using (jugglecontext dbcon = new jugglecontext())
{
tbl_worktype work_type = dbcon.tbl_worktype.Where(x => x.work_id == work_id).FirstOrDefault();
tbl_worktype prod = new tbl_worktype();
prod.work_id = work_type.work_id;
prod.name = work_type.name;
prod.color = work_type.color;
prod.time = work_type.time;
prod.user_id = work_type.user_id;
prod.created_date = work_type.created_date;
var content = from p in dbcon.servicetypetimes
select new { p.value, p.timeinminute };
var y = content.ToList().Select(c => new SelectListItem
{
Text = c.timeinminute.ToString(),
Value = c.value.ToString(),
}).ToList();
ViewBag.servicetypeminute = y;
return(View(prod));
}
}
catch
{
return(View());
}
}
else
{
return(View("Login", "Account"));
}
}
public ActionResult Create_Worktype(juggle.Models.tbl_worktype work_type)
{
using (jugglecontext dbcon = new jugglecontext())
{
try
{
tbl_worktype worktype = new tbl_worktype();
worktype.name = work_type.name.Trim();
worktype.color = work_type.color.Trim();
worktype.worktypecat_id = Convert.ToInt32(work_type.worktypecat_id);
worktype.user_id = Convert.ToInt32(Session["User_Id"]);
worktype.created_date = DateTime.Now;
dbcon.tbl_worktype.Add(worktype);
dbcon.SaveChanges();
return(RedirectToAction("Worktype", "Worktype"));
}
catch (Exception ex)
{
return(View(work_type));
}
}
}
