public static string ManageDelete(NameValueCollection querystring)
{
int intParser;
UserProfile userProfile = WebCommon.GetUserProfile();
var BnkRecon = new RepoReAppraiseDetail
{
ID = int.TryParse(querystring.Get("ID"), out intParser) ? intParser : 0,
intIDAppraisal = int.TryParse(querystring.Get("intIDAppraisal"), out intParser) ? intParser : 0,
};
string param = WebCommon.ToXML(BnkRecon);
return(RepoReAppraisalDAL.ManageDelete(param));
}
public static string ManageUpdate(NameValueCollection querystring)
{
// var params = '';
//params += 'ID=' + cttID;
//params += '&intIDAppraisal=' + cttRepoAppraisalID;
//params += '&datReAppraisal=' + cttDateReAppraise;
//params += '&amtReAppraisal=' + cttAmountReAppraise;
//params += '&AppraiseBy=' + cttRemarks;
int intParser;
decimal decimalParser;
bool apr;
UserProfile userProfile = WebCommon.GetUserProfile();
var BnkRecon = new RepoReAppraiseDetail
{
ID = int.TryParse(querystring.Get("ID"), out intParser) ? intParser : 0,
intIDAppraisal = int.TryParse(querystring.Get("intIDAppraisal"), out intParser) ? intParser : 0,
datReAppraisal = querystring.Get("datReAppraisal"),
amtReAppraisal = decimal.TryParse(querystring.Get("amtReAppraisal"), out decimalParser) ? decimalParser : 0,
AppraiseBy = querystring.Get("AppraiseBy"),
percentage = decimal.TryParse(querystring.Get("curPercentage"), out decimalParser) ? decimalParser : 0,
approved = bool.TryParse(querystring.Get("bolApprove"), out apr) ? apr : false,
approvedOM = bool.TryParse(querystring.Get("bolApproveOM"), out apr) ? apr : false,
appuserid = userProfile.UserId,
};
// params += 'ID=' + cttID;
//params += '&intIDAppraisal=' + cttRepoAppraisalID;
//params += '&datReAppraisal=' + cttDateReAppraise;
//params += '&amtReAppraisal=' + cttAmountReAppraise;
//params += '&AppraiseBy=' + cttRemarks;
//params += '&curPercentage=' + cttPercentage;
//params += '&bolApprove=' + cttApproval;
//params += '&intUserID=' + cttUserID;
string param = WebCommon.ToXML(BnkRecon);
return(RepoReAppraisalDAL.ManageUpdate(param));
}
public static List <RepoReAppraiseDetail> GetReAppraisalDetail(int AppraisalID)
{
var dbUtil = new DatabaseManager();
var brHeader = new List <RepoReAppraiseDetail>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spReAppraisalGetDetail";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@AppraisalID", AppraisalID);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var brhdr = new RepoReAppraiseDetail
{
ID = ReferenceEquals(reader["ID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["ID"]),
intIDAppraisal = ReferenceEquals(reader["intIDSalMCRepoAppraisal"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDSalMCRepoAppraisal"]),
datReAppraisal = ReferenceEquals(reader["datReAppraisal"], DBNull.Value) ? String.Empty : Convert.ToString(reader["datReAppraisal"]),
amtReAppraisal = ReferenceEquals(reader["numReAppaisalValue"], DBNull.Value) ? 0: Convert.ToDecimal(reader["numReAppaisalValue"]),
AppraiseBy = ReferenceEquals(reader["strAppraiseBy"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strAppraiseBy"]),
percentage = ReferenceEquals(reader["percentage"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["percentage"]),
approved = ReferenceEquals(reader["approved"], DBNull.Value) ? false : Convert.ToBoolean(reader["approved"]),
approvedOM = ReferenceEquals(reader["approvedOM"], DBNull.Value) ? false : Convert.ToBoolean(reader["approvedOM"]),
appuserid = ReferenceEquals(reader["appuserid"], DBNull.Value) ? 0 : Convert.ToInt32(reader["appuserid"]),
};
brHeader.Add(brhdr);
}
return(brHeader);
}
}
}
}
