public ActionResult CreateUtilitiesDetails(M_UtilitiesDetails 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_UtilitiesDetails]" + " ([UtilitiesID]" + " ,[CriteriaID]" + " ,[DetailsName]" + " ,[Unit]" + " ,[IsDeleted]" + " ,[CreateID]" + " ,[CreateDate]" + " ,[UpdateID]" + " ,[UpdateDate])" + "VALUES" + " ('" + data.UtilitiesID + "'," + " '" + data.CriteriaID + "'," + " '" + data.DetailsName + "'," + " '" + data.Unit + "'," + " '" + 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 UpdateUtilitiesDetails(M_UtilitiesDetails data) { try { data.CreateID = user.EmployeeNo; data.CreateDate = DateTime.Now; data.UpdateID = user.EmployeeNo; data.UpdateDate = DateTime.Now; string Query = ""; Query += "UPDATE [dbo].[M_UtilitiesDetails] SET " + " [UtilitiesID] = '" + data.UtilitiesID + "'" + " ,[CriteriaID] = '" + data.CriteriaID + "'" + " ,[DetailsName] = '" + data.DetailsName + "'" + " ,[Unit] = '" + data.Unit + "'" + " ,[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)); } }