public static HORep_ManageResultString SaveHOReplenishment(HORep_CVForReplenishment HORep, DataTable tblHORepDetails)
{
var manageResult = new HORep_ManageResultString();
try
{
var dbUtil = new DatabaseManager();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
string result = string.Empty;
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spDisHORep_SaveHOReplenishment";
cmd.CommandTimeout = 180;
cmd.Parameters.AddWithValue("@ID", HORep.ID);
cmd.Parameters.AddWithValue("@TransactionDate", HORep.TransactionDate);
cmd.Parameters.AddWithValue("@intIDMasPayee", HORep.intIDMasPayee);
cmd.Parameters.AddWithValue("@intIDMasCOAIndividualSubsidiaryRF", HORep.intIDMasCOAIndividualSubsidiaryRF);
cmd.Parameters.AddWithValue("@intIDMasCOAIndividualSubsidiaryCiB", HORep.intIDMasCOAIndividualSubsidiaryCiB);
cmd.Parameters.AddWithValue("@strCheckNo", HORep.strCheckNo);
cmd.Parameters.AddWithValue("@CheckDate", HORep.CheckDate);
cmd.Parameters.AddWithValue("@curAmount", HORep.curAmount);
cmd.Parameters.AddWithValue("@strParticulars", HORep.strParticulars);
cmd.Parameters.AddWithValue("@intIDSecUser", HORep.intIDSecUser);
cmd.Parameters.AddWithValue("@HORep_CVForReplenishmentDetail", tblHORepDetails);
result = (string)cmd.ExecuteScalar();
}
if (result.Contains("Success"))
{
string[] separators = { "," };
string[] words = result.Split(separators, StringSplitOptions.RemoveEmptyEntries);
manageResult.Message = words[0].ToString();
manageResult.Code = words[1].ToString();
manageResult.ID = int.Parse(words[2].ToString());
}
else
{
manageResult.Message = result;
manageResult.Code = "";
manageResult.ID = 0;
}
}
}
catch (Exception ex)
{
manageResult.Message = "Error: " + ex.ToString();
manageResult.Code = "";
manageResult.ID = 0;
}
return(manageResult);
}
private void SaveHOReplenishment()
{
try
{
HORep_ManageResultString result = new HORep_ManageResultString();
result = HOReplenishmentBAL.SaveHOReplenishment(Request.QueryString, Request.Form);
Response.Write(result.ToJSON());
}
catch (Exception ex)
{
Response.Write("Error: " + ex.ToString());
}
}
