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