public static ManageResult manage(LtoManualCV_ManualCV mst) { var manageResult = new ManageResult(); 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 = "spLtoManualCV_manage"; cmd.CommandTimeout = 180; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@intIDLtoManualCV", mst.intIDLtoManualCV); cmd.Parameters.AddWithValue("@intIDLtoRFBankAccounts", mst.intIDLtoRFBankAccounts); cmd.Parameters.AddWithValue("@DateAsOf", mst.DateAsOf); cmd.Parameters.AddWithValue("@intLeadTime", mst.intLeadTime); cmd.Parameters.AddWithValue("@BalanceLastMonth", mst.BalanceLastMonth); cmd.Parameters.AddWithValue("@CAAmount", mst.CAAmount); cmd.Parameters.AddWithValue("@TotalLiquidation", mst.TotalLiquidation); cmd.Parameters.AddWithValue("@UnliquidatedBalance", mst.UnliquidatedBalance); cmd.Parameters.AddWithValue("@CurrentAmount", mst.CurrentAmount); cmd.Parameters.AddWithValue("@BeyondAmount", mst.BeyondAmount); cmd.Parameters.AddWithValue("@intIDSecUser", mst.intIDSecUser); cmd.Parameters.AddWithValue("@intIDMasLocation", mst.intIDMasLocation); result = (string)cmd.ExecuteScalar(); } if (result.Contains("Success121")) { string[] separators = { "," }; string[] words = result.Split(separators, StringSplitOptions.RemoveEmptyEntries); manageResult.Message = "Success"; manageResult.ID = int.Parse(words[1].ToString()); } else { manageResult.Message = result; manageResult.ID = 0; } } } catch (Exception ex) { manageResult.Message = "Error: " + ex.ToString(); manageResult.ID = 0; } return(manageResult); }
public static List <LtoManualCV_ManualCV> getManualCV(int intIDLtoRFBankAccounts, int intYear, int intIDSecUser, int intIDMasLocation) { var dbUtil = new DatabaseManager(); var ltoList = new List <LtoManualCV_ManualCV>(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spLtoManualCV_getManualCV"; cmd.CommandTimeout = 180; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@intIDLtoRFBankAccounts", intIDLtoRFBankAccounts); cmd.Parameters.AddWithValue("@intYear", intYear); cmd.Parameters.AddWithValue("@intIDSecUser", intIDSecUser); cmd.Parameters.AddWithValue("@intIDMasLocation", intIDMasLocation); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var item = new LtoManualCV_ManualCV { intIDLtoManualCV = int.Parse(reader["intIDLtoManualCV"].ToString()), DateAsOf = reader["DateAsOf"].ToString(), intLeadTime = int.Parse(reader["intLeadTime"].ToString()), BalanceLastMonth = decimal.Parse(reader["BalanceLastMonth"].ToString()), CAAmount = decimal.Parse(reader["CAAmount"].ToString()), TotalLiquidation = decimal.Parse(reader["TotalLiquidation"].ToString()), UnliquidatedBalance = decimal.Parse(reader["UnliquidatedBalance"].ToString()), CurrentAmount = decimal.Parse(reader["CurrentAmount"].ToString()), BeyondAmount = decimal.Parse(reader["BeyondAmount"].ToString()) }; ltoList.Add(item); } return(ltoList); } } } }
public static ManageResult manage(NameValueCollection querystring) { UserProfile userProfile = WebCommon.GetUserProfile(); var mst = new LtoManualCV_ManualCV { intIDLtoManualCV = int.Parse(querystring.Get("intIDLtoManualCV")), intIDLtoRFBankAccounts = int.Parse(querystring.Get("intIDLtoRFBankAccounts")), DateAsOf = querystring.Get("DateAsOf"), intLeadTime = int.Parse(querystring.Get("intLeadTime")), BalanceLastMonth = decimal.Parse(querystring.Get("BalanceLastMonth")), CAAmount = decimal.Parse(querystring.Get("CAAmount")), TotalLiquidation = decimal.Parse(querystring.Get("TotalLiquidation")), UnliquidatedBalance = decimal.Parse(querystring.Get("UnliquidatedBalance")), CurrentAmount = decimal.Parse(querystring.Get("CurrentAmount")), BeyondAmount = decimal.Parse(querystring.Get("BeyondAmount")), intIDSecUser = int.Parse(userProfile.UserId.ToString()), intIDMasLocation = int.Parse(querystring.Get("intIDMasLocation")), }; return(LtoManualCVDal.manage(mst)); }