public List <ChargeTypeModel> GetChargeTypeList(string ChargeType)
{
ShomaRMEntities db = new ShomaRMEntities();
List <ChargeTypeModel> model = new List <ChargeTypeModel>();
try
{
DataTable dtTable = new DataTable();
using (var cmd = db.Database.Connection.CreateCommand())
{
db.Database.Connection.Open();
cmd.CommandText = "usp_GetChargeTypeList";
cmd.CommandType = CommandType.StoredProcedure;
DbParameter paramC = cmd.CreateParameter();
paramC.ParameterName = "Criteria";
paramC.Value = ChargeType;
cmd.Parameters.Add(paramC);
DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter();
da.SelectCommand = cmd;
da.Fill(dtTable);
db.Database.Connection.Close();
}
foreach (DataRow dr in dtTable.Rows)
{
ChargeTypeModel usm = new ChargeTypeModel();
usm.CTID = int.Parse(dr["CTID"].ToString());
usm.Charge_Type = dr["Charge_Type"].ToString();
usm.Charge_Description = dr["Charge_Description"].ToString();
model.Add(usm);
}
db.Dispose();
return(model);
}
catch (Exception ex)
{
db.Database.Connection.Close();
throw ex;
}
}
public long SaveUpdateChargeType(ChargeTypeModel model)
{
ShomaRMEntities db = new ShomaRMEntities();
var ChargeTypeExists = db.tbl_ChargeType.Where(p => p.CTID != model.CTID && p.Charge_Type == model.Charge_Type).FirstOrDefault();
if (ChargeTypeExists == null)
{
if (model.CTID == 0)
{
var data = new tbl_ChargeType()
{
Charge_Type = model.Charge_Type,
Charge_Description = model.Charge_Description,
};
db.tbl_ChargeType.Add(data);
db.SaveChanges();
model.CTID = data.CTID;
}
else
{
var ChargeTypeInfo = db.tbl_ChargeType.Where(p => p.CTID == model.CTID).FirstOrDefault();
if (ChargeTypeInfo != null)
{
ChargeTypeInfo.Charge_Type = model.Charge_Type;
ChargeTypeInfo.Charge_Description = model.Charge_Description;
db.SaveChanges();
}
else
{
throw new Exception(model.Charge_Type + " not exists in the system.");
}
}
return(model.CTID);
}
else
{
throw new Exception(model.Charge_Type + " already exists in the system.");
}
}
public ChargeTypeModel GetChargeTypeInfo(int CTID = 0)
{
ShomaRMEntities db = new ShomaRMEntities();
ChargeTypeModel model = new ChargeTypeModel();
model.CTID = 0;
model.Charge_Type = "";
model.Charge_Description = "";
var ChargeTypeInfo = db.tbl_ChargeType.Where(p => p.CTID == CTID).FirstOrDefault();
if (ChargeTypeInfo != null)
{
model.CTID = ChargeTypeInfo.CTID;
model.Charge_Type = ChargeTypeInfo.Charge_Type;
model.Charge_Description = ChargeTypeInfo.Charge_Description;
model.Summary_Charge_Type = ChargeTypeInfo.Summary_Charge_Type;
model.Revenue_Account = ChargeTypeInfo.Revenue_Account;
model.Payment_Description = ChargeTypeInfo.Payment_Description;
}
return(model);
}