public static string Manage(NameValueCollection querystring, NameValueCollection formdata)
{
int intParser;
decimal decimalParser;
UserProfile userProfile = WebCommon.GetUserProfile();
var cvfgls = new List <RepoReAppraiseDetail>();
string isInsert = querystring.Get("transType");
cvfgls = (List <RepoReAppraiseDetail>)cvfgls.ToClass(formdata["Data"]);
var BnkRecon = new RepoReAppraiseHeader
{
ID = int.TryParse(querystring.Get("AppraisalID"), out intParser) ? intParser : 0,
intIDMasLocation = int.TryParse(querystring.Get("BranchID"), out intParser) ? intParser : 0,
datTransaction = querystring.Get("Date"),
datAdjustment = querystring.Get("DateAdjust"),
strAccountCode = querystring.Get("AccountCode"),
strAccountName = querystring.Get("AccountName"),
numAmountAppraise = decimal.TryParse(querystring.Get("AmountAppraisal"), out decimalParser) ? decimalParser : 0,
intUserID = userProfile.UserId,
numNewLCP = decimal.TryParse(querystring.Get("NewLCP"), out decimalParser) ? decimalParser : 0,
RepoReAppraiseDetails = cvfgls
};
string param = WebCommon.ToXML(BnkRecon);
return(RepoReAppraisalDAL.Manage(param, isInsert));
}
public static List <RepoReAppraiseHeader> GetReAppraisal(string criteria, int branchID)
{
var dbUtil = new DatabaseManager();
var brHeader = new List <RepoReAppraiseHeader>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spReAppraisalGetHdr";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@strCriteria", criteria);
cmd.Parameters.AddWithValue("@intBranchID", branchID);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var brhdr = new RepoReAppraiseHeader
{
ID = ReferenceEquals(reader["ID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["ID"]),
intIDMasLocation = ReferenceEquals(reader["intIDMasLocation"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasLocation"]),
datAdjustment = ReferenceEquals(reader["datAdjustment"], DBNull.Value) ? String.Empty : Convert.ToString(reader["datAdjustment"]),
datTransaction = ReferenceEquals(reader["datTransaction"], DBNull.Value) ? String.Empty : Convert.ToString(reader["datTransaction"]),
strAccountCode = ReferenceEquals(reader["strAccountCode"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strAccountCode"]),
strAccountName = ReferenceEquals(reader["strAccountName"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strAccountName"]),
numAmountAppraise = ReferenceEquals(reader["numAmountAppraise"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["numAmountAppraise"]),
numNewLCP = ReferenceEquals(reader["numNewLCP"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["numNewLCP"]),
};
brHeader.Add(brhdr);
}
return(brHeader);
}
}
}
}
