public ActionResult UpdateDivision(M_Division data)
{
try
{
data.CreateID = user.EmployeeNo;
data.CreateDate = DateTime.Now;
data.UpdateID = user.EmployeeNo;
data.UpdateDate = DateTime.Now;
string Query = "";
Query += "UPDATE [dbo].[M_Division] SET " +
" [DivisionName] = '" + data.DivisionName + "'" +
" ,[UpdateID]= '" + data.UpdateID + "'" +
" ,[UpdateDate]= '" + data.UpdateDate + "'" +
" WHERE [ID] = '" + data.ID + "'";
SqlCommand cmdSql = new SqlCommand();
cmdSql.Connection = conn;
cmdSql.CommandTimeout = 0;
cmdSql.CommandText = Query;
conn.Open();
cmdSql.ExecuteNonQuery();
conn.Close();
return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception err)
{
return(Json(new { msg = err.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetDivisionList()
{
try
{
//Server Side Parameter
int start = (Convert.ToInt32(Request["start"]) == 0) ? 0 : (Convert.ToInt32(Request["start"]) / Convert.ToInt32(Request["length"])); //Convert.ToInt32(Request["start"]);
int length = Convert.ToInt32(Request["length"]);
string searchValue = Request["search[value]"];
string sortColumnName = Request["columns[" + Request["order[0][column]"] + "][name]"];
string sortDirection = Request["order[0][dir]"];
//ObjectParameter totalCount = new ObjectParameter("RecordCount", typeof(int));
List <M_Division> list = new List <M_Division>();
SqlCommand cmdSql = new SqlCommand();
cmdSql.Connection = conn;
cmdSql.CommandTimeout = 0;
cmdSql.CommandText = "SELECT * FROM M_Division WHERE IsDeleted <> 1";
cmdSql.CommandTimeout = 0;
conn.Open();
//cmdSql.ExecuteNonQuery();
using (SqlDataReader rdr = cmdSql.ExecuteReader())
{
while (rdr.Read())
{
M_Division getter = new M_Division();
getter.ID = Convert.ToInt32(rdr["ID"]);//.ToString();
getter.DivisionName = rdr["DivisionName"].ToString();
//getter.DepartmentList = GetDeparmentList(getter.ID);
list.Add(getter);
}
}
int totalCount = list.Count;
conn.Close();
int?totalrows = totalCount;
int?totalrowsafterfiltering = totalCount;
foreach (M_Division m in list)
{
m.DepartmentList = GetDeparmentList(m.ID);
}
return(Json(new { data = list }, JsonRequestBehavior.AllowGet));
//return Json(new { data = list, draw = Request["draw"], recordsTotal = totalrows, recordsFiltered = totalrowsafterfiltering }, JsonRequestBehavior.AllowGet);
}
catch (Exception err)
{
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult CreateDivision(M_Division data)
{
try
{
data.CreateID = user.EmployeeNo;
data.CreateDate = DateTime.Now;
data.UpdateID = user.EmployeeNo;
data.UpdateDate = DateTime.Now;
string Query = "";
Query += "INSERT INTO [dbo].[M_Division]" +
" ([DivisionName]" +
" ,[IsDeleted]" +
" ,[CreateID]" +
" ,[CreateDate]" +
" ,[UpdateID]" +
" ,[UpdateDate])" +
"VALUES" +
" ('" + data.DivisionName + "'," +
" '" + 0 + "'," +
" '" + data.CreateID + "'," +
" '" + data.CreateDate + "'," +
" '" + data.UpdateID + "'," +
" '" + data.UpdateDate + "')";
SqlCommand cmdSql = new SqlCommand();
cmdSql.Connection = conn;
cmdSql.CommandTimeout = 0;
cmdSql.CommandText = Query;
conn.Open();
cmdSql.ExecuteNonQuery();
conn.Close();
return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception err)
{
return(Json(new { msg = err.Message }, JsonRequestBehavior.AllowGet));
}
}
