public int AddNewProjectIncome(ProjectIncome projectIncome)
{
string sql =
$@"INSERT INTO [dbo].[Project_Income]([Project_Income_Id], [Project_Id], [Note], [Amount], [In_Datetime]) VALUES (@Project_Income_Id, '{projectIncome.Project.Project_Id}', @Note, @Amount, @In_Datetime);";
return(unitOfWork.Connection.Execute(sql, projectIncome, unitOfWork.Transaction));
}
private List <ProjectIncome> MapPersonalIncome(DataTable dt)
{
List <ProjectIncome> result = new List <ProjectIncome>();
int totalExpense = 0;
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
ProjectIncome obj = new ProjectIncome();
obj.ProjectIncomeId = Convert.ToInt32(dr["PersonalIncomeId"]);
obj.TotalCount = Convert.ToInt32(dr["TotalCount"]);
obj.Amount = dr["Amount"].ToString();
obj.IncomeDate = Convert.ToDateTime(dr["IncomeDate"]).ToString("dd/MM/yyyy");
obj.IncomeName = dr["IncomeName"].ToString();
obj.TotalIncome = Convert.ToInt32(dr["TotalIncome"]);
result.Add(obj);
}
}
return(result);
}
