public int AddBudGet(t_EE_EneryUsreBudget model)
{
string sql = $@"insert into t_EE_EneryUsreBudget(EneryUserID,CollTypeID,GeneralBudget)
values({model.EneryUserID},{model.CollTypeID},{model.GeneralBudget})";
return(ExecuteSqlCommand(sql));
}
public int UpdateBudGet(t_EE_EneryUsreBudget model)
{
int n = 0;
try
{
n = _dbFactory.eneryUserBudget.UpdateBudGet(model);
}
catch (Exception ex)
{
throw ex;
}
return(n);
}
public t_EE_EneryUsreBudget GetenBudgetByID(int id)
{
t_EE_EneryUsreBudget data = new t_EE_EneryUsreBudget();
try
{
data = _dbFactory.eneryUserBudget.GetenBudgetByID(id);
}
catch (Exception ex)
{
throw ex;
}
return(data);
}
public t_EE_EneryUsreBudget GetenBudgetByeneyidAndCoID(int cotyid, int eneryid)
{
t_EE_EneryUsreBudget data = new t_EE_EneryUsreBudget();
try
{
data = _dbFactory.eneryUserBudget.GetenBudgetByeneyidAndCoID(cotyid, eneryid);
}
catch (Exception ex)
{
throw ex;
}
return(data);
}
public int UpdateBudGet(t_EE_EneryUsreBudget model)
{
string sql = $@"update t_EE_EneryUsreBudget set EneryUserID={model.EneryUserID},CollTypeID={model.CollTypeID},GeneralBudget={model.GeneralBudget} where ID={model.ID}";
return(ExecuteSqlCommand(sql));
}
