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());
}
}
