public PODStatus GetPODStatusById(Guid id) { string sqlCommand = "spGetById"; using (SqlCommand cmd = General.GetCommand(sqlCommand, Table.m_pod, id)) { using (SqlDataAdapter sdAdapter = new SqlDataAdapter(cmd)) { DataSet ds = new DataSet(); sdAdapter.Fill(ds, "m_pod"); PODStatus podStatus = new PODStatus(); foreach (DataRow dr in ds.Tables["m_pod"].Rows) { podStatus.kode = int.Parse(dr["kode"].ToString()); podStatus.nm = dr["nm"] as string; podStatus.statusx = (dr["statusx"] as string).Trim(); podStatus.kode_relasi = (dr["kode_relasi"] as string).Trim(); podStatus.id = Guid.Parse(dr["id"].ToString()); } return(podStatus); } } }
public JsonResult AddEditPODStatus(PODStatus podStatus) { if (ModelState.IsValid) { db.AddEditPODStatus(podStatus); } string status = podStatus.id != Guid.Empty ? "updated" : "saved"; string message = $"POD Status has been {status} successfully"; return(Json(message, JsonRequestBehavior.AllowGet)); }
public int AddEditPODStatus(PODStatus podStatus) { string sqlCommand = "spAddEditPODStatus"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@nm", podStatus.nm); parameters.Add("@statusx", podStatus.statusx); parameters.Add("@kode_relasi", podStatus.kode_relasi); parameters.Add("@id", podStatus.id); using (SqlCommand cmd = General.GetCommand(sqlCommand, parameters)) { if (cmd.Connection.State == ConnectionState.Closed) { cmd.Connection.Open(); } return(cmd.ExecuteNonQuery()); } }