public ActionResult Updateholidays(M_Holidays data)
{
try
{
data.CreateID = user.EmployeeNo;
data.CreateDate = DateTime.Now;
data.UpdateID = user.EmployeeNo;
data.UpdateDate = DateTime.Now;
string Query = "";
Query += "UPDATE [dbo].[M_Holidays] SET " +
" [HolidayName] = '" + data.HolidayName + "'" +
" ,[HolidayDate]= '" + data.HolidayDate + "'" +
" ,[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 Createholidays(M_Holidays 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_Holidays]" +
" ([HolidayName]" +
" ,[HolidayDate]" +
" ,[Type]" +
" ,[IsDeleted]" +
" ,[CreateID]" +
" ,[CreateDate]" +
" ,[UpdateID]" +
" ,[UpdateDate])" +
"VALUES" +
" ('" + data.HolidayName + "'," +
" '" + data.HolidayDate + "'," +
" '" + data.Type + "'," +
" '" + 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));
}
}
