public static ManageResultString VerifyCA(LTOLiq_VerifiedCA verifiedCA)
{
var manageResult = new ManageResultString();
try
{
var dbUtil = new DatabaseManager();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
string result;
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spLtoLiq_VerifyCA";
cmd.CommandTimeout = 180;
cmd.Parameters.AddWithValue("@intIDLTOLiquidation", verifiedCA.intIDLTOLiquidation);
cmd.Parameters.AddWithValue("@intIDLTOCashAdvance", verifiedCA.intIDLTOCashAdvance);
cmd.Parameters.AddWithValue("@Remarks", verifiedCA.Remarks);
cmd.Parameters.AddWithValue("@TransactionDate", verifiedCA.TransactionDate);
cmd.Parameters.AddWithValue("@ReceivedDate", verifiedCA.ReceivedDate);
cmd.Parameters.AddWithValue("@intIDColCollection", verifiedCA.intIDColCollection);
cmd.Parameters.AddWithValue("@ARNumber", (verifiedCA.ARNumber == null) ? string.Empty : verifiedCA.ARNumber);
cmd.Parameters.AddWithValue("@ARDate", (verifiedCA.ARDate == null) ? string.Empty : verifiedCA.ARDate);
cmd.Parameters.AddWithValue("@ARAmount", verifiedCA.ARAmount);
cmd.Parameters.AddWithValue("@intIDSecUser", verifiedCA.intIDSecUser);
cmd.Parameters.AddWithValue("@transType", verifiedCA.type);
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);
}
public static ManageResultString VerifyCA(NameValueCollection querystring)
{
UserProfile userprofile = WebCommon.GetUserProfile();
var verifiedCA = new LTOLiq_VerifiedCA();
int intIDColCollection;
decimal ARAmount;
verifiedCA.intIDLTOCashAdvance = int.Parse(querystring.Get("intIDLTOCashAdvance"));
verifiedCA.intIDLTOLiquidation = int.Parse(querystring.Get("intIDLTOLiquidation"));
verifiedCA.TransactionDate = querystring.Get("TransactionDate");
verifiedCA.ReceivedDate = querystring.Get("ReceivedDate");
verifiedCA.Remarks = querystring.Get("Remarks");
verifiedCA.intIDColCollection = int.TryParse(querystring.Get("intIDColCollection"), out intIDColCollection) ? intIDColCollection : 0;
verifiedCA.ARNumber = querystring.Get("ARNumber");
verifiedCA.ARDate = querystring.Get("ARDate");
verifiedCA.ARAmount = decimal.TryParse(querystring.Get("ARAmount"), out ARAmount) ? ARAmount : 0;
verifiedCA.intIDSecUser = int.Parse(userprofile.UserId.ToString());
verifiedCA.type = querystring.Get("transType");
return(LTOLiquidationDAL.VerifyCA(verifiedCA));
}
