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); }