public static List <MCMICategoryDetail> GetMCMICategoryDetail(int branchid)
{
var dbUtil = new DatabaseManager();
//var customers = new List<Payee>();
var MCMICategoryDetails = new List <MCMICategoryDetail>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spMasGetMCFactorPerLocation";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@intIDMasLocation", branchid);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var MCMICategoryDetail = new MCMICategoryDetail
{
MCMICategoryDetailID = ReferenceEquals(reader["intIDCalcMICategoryDetail"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDCalcMICategoryDetail"]),
MCMICategoryID = ReferenceEquals(reader["intIDMICatHeader"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMICatHeader"]),
MCMICategoryName = ReferenceEquals(reader["strMCCalcNameCategory"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strMCCalcNameCategory"]),
Month = ReferenceEquals(reader["intIDMonth"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMonth"]),
Factor = ReferenceEquals(reader["curFactor"], DBNull.Value) ? 0 : Convert.ToSingle(reader["curFactor"]),
BranchID = ReferenceEquals(reader["intIDMasLocation"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasLocation"]),
BranchName = ReferenceEquals(reader["strBranchName"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strBranchName"]),
};
MCMICategoryDetails.Add(MCMICategoryDetail);
}
return(MCMICategoryDetails);
}
}
}
}
public static string ManageMCMICategoryDetail(NameValueCollection querystring)
{
int integerParse;
float floatParse;
UserProfile userProfile = WebCommon.GetUserProfile();
var MCMICategoryDetail = new MCMICategoryDetail
{
MCMICategoryDetailID = int.TryParse(querystring.Get("MCMICategoryDetailID"), out integerParse) ? integerParse : 0,
MCMICategoryID = int.TryParse(querystring.Get("MCMICategoryID"), out integerParse) ? integerParse : 0,
BranchID = int.TryParse(querystring.Get("BranchID"), out integerParse) ? integerParse : 0,
Factor = float.TryParse(querystring.Get("Factor"), out floatParse) ? floatParse : 0,
Month = int.TryParse(querystring.Get("Month"), out integerParse) ? integerParse : 0
// UserID = userProfile.UserId
};
string isInsert = querystring.Get("TransType");
string param = WebCommon.ToXML(MCMICategoryDetail);
return(MCMICategoryDetailDAL.ManageMCMICategoryDetail(param, isInsert));
}
