public ActionResult CreateTimeFrame(M_TimeFrame 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_TimeFrame]" +
" ([WorkCategory]" +
" ,[WorkingDays]" +
" ,[PriorityLevel]" +
" ,[ScoreFrom]" +
" ,[ScoreTo]" +
" ,[PriorityLevelRemarks]" +
" ,[IsDeleted]" +
" ,[CreateID]" +
" ,[CreateDate]" +
" ,[UpdateID]" +
" ,[UpdateDate])" +
"VALUES" +
" ('" + data.WorkCategory + "'," +
" '" + data.WorkingDays + "'," +
" '" + data.PriorityLevel + "'," +
" '" + data.ScoreFrom + "'," +
" '" + data.ScoreTo + "'," +
" '" + data.PriorityLevelRemarks + "'," +
" '" + 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));
}
}
public ActionResult UpdateTimeFrame(M_TimeFrame data)
{
try
{
data.CreateID = user.EmployeeNo;
data.CreateDate = DateTime.Now;
data.UpdateID = user.EmployeeNo;
data.UpdateDate = DateTime.Now;
string Query = "";
Query += "UPDATE [dbo].[M_TimeFrame] SET " +
" [WorkingDays] = '" + data.WorkingDays + "'" +
" ,[PriorityLevel] = '" + data.PriorityLevel + "'" +
" ,[ScoreFrom] = '" + data.ScoreFrom + "'" +
" ,[ScoreTo] = '" + data.ScoreTo + "'" +
" ,[PriorityLevelRemarks] = '" + data.PriorityLevelRemarks + "'" +
" ,[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));
}
}
