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