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