public TermInvoice GetTermInvoice(Guid id)
{
string sqlCommand = "spGetTermInvoice";
using (SqlCommand cmd = General.GetCommand(sqlCommand))
{
cmd.Parameters.Add("@id", SqlDbType.UniqueIdentifier, 16).Value = id;
using (SqlDataAdapter sdAdapter = new SqlDataAdapter(cmd))
{
DataSet ds = new DataSet();
sdAdapter.Fill(ds, "m_term");
TermInvoice termInvoice = new TermInvoice();
foreach (DataRow dr in ds.Tables["m_term"].Rows)
{
termInvoice.cust_id = Guid.Parse(dr["id"].ToString());
termInvoice.nm = dr["nm"] as string;
termInvoice.termx = dr["termx"] as string;
termInvoice.descx = dr["descx"] as string;
}
return(termInvoice);
}
}
}
public JsonResult AddEditTermInvoice(TermInvoice termInvoice)
{
if (ModelState.IsValid)
{
db.AddEditTermInvoice(termInvoice);
}
string status = termInvoice.cust_id != Guid.Empty ? "updated" : "saved";
string message = $"Term Invoice has been {status} successfully";
return(Json(message, JsonRequestBehavior.AllowGet));
}
public int AddEditTermInvoice(TermInvoice termInvoice)
{
string sqlCommand = "spAddEditTermInvoice";
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@cust_id", termInvoice.cust_id);
parameters.Add("@nm", termInvoice.nm);
parameters.Add("@termx", termInvoice.termx);
parameters.Add("@descx", termInvoice.descx);
using (SqlCommand cmd = General.GetCommand(sqlCommand, parameters))
{
if (cmd.Connection.State == ConnectionState.Closed)
{
cmd.Connection.Open();
}
return(cmd.ExecuteNonQuery());
}
}
