public static string ManageMCBranchPPR(NameValueCollection querystring)
{
int integerParse;
decimal decimalParse;
UserProfile userProfile = WebCommon.GetUserProfile();
var MCBranchPPR = new MCBranchPPR
{
MCBranchPPRID = int.TryParse(querystring.Get("MCBranchPPRID"), out integerParse) ? integerParse : 0,
MCModelID = int.TryParse(querystring.Get("MCModelID"), out integerParse) ? integerParse : 0,
BranchID = int.TryParse(querystring.Get("BranchID"), out integerParse) ? integerParse : 0,
PPR = decimal.TryParse(querystring.Get("PPR"), out decimalParse) ? decimalParse : 0
// UserID = userProfile.UserId
};
string isInsert = querystring.Get("TransType");
string param = WebCommon.ToXML(MCBranchPPR);
return(MCBranchPPRDAL.ManageMCBranchPPR(param, isInsert));
}
public static List <MCBranchPPR> GetMCBranchPPR(int branchid)
{
var dbUtil = new DatabaseManager();
//var customers = new List<Payee>();
var MCBranchPPRs = new List <MCBranchPPR>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spMasGetPPRPerLocation";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@intIDMasLocation", branchid);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var MCBranchPPR = new MCBranchPPR
{
MCBranchPPRID = ReferenceEquals(reader["intIDBranchPPR"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDBranchPPR"]),
MCModelID = ReferenceEquals(reader["intIDMasMC"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasMC"]),
MCName = ReferenceEquals(reader["strMCName"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strMCName"]),
BranchID = ReferenceEquals(reader["intIDMasLocation"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasLocation"]),
BranchName = ReferenceEquals(reader["strBranchName"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strBranchName"]),
PPR = ReferenceEquals(reader["curPPR"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curPPR"])
};
MCBranchPPRs.Add(MCBranchPPR);
}
return(MCBranchPPRs);
}
}
}
}
