public static int Save(BOLeaveDetailsList entryList, bool adding) { tblLeaveDetails tblObj = new tblLeaveDetails(); DataTable dt = tblObj.Table(); int i = 0; foreach(BOLeaveDetails entry in entryList) { DataRow newRow = tblObj.Table().NewRow(); newRow[tblLeaveDetails.EMPLOYEEID_FIELD] = entry.EmployeeID; newRow[tblLeaveDetails.TOTALCASUALLEAVE_FIELD] = entry.TotalCasualLeave; newRow[tblLeaveDetails.TOTALSICKLEAVE_FIELD] = entry.TotalSickLeave; newRow[tblLeaveDetails.LEAVETYPE_FIELD] = entry.LeaveType; newRow[tblLeaveDetails.ISAPPROVED_FIELD] = entry.IsApproved; newRow[tblLeaveDetails.APPROVEDBYID_FIELD] = entry.ApprovedByID; if(entry.ToDate.Equals(new DateTime())) newRow[tblLeaveDetails.TODATE_FIELD] = DBNull.Value; else newRow[tblLeaveDetails.TODATE_FIELD] = entry.ToDate; if(entry.FromDate.Equals(new DateTime())) newRow[tblLeaveDetails.FROMDATE_FIELD] = DBNull.Value; else newRow[tblLeaveDetails.FROMDATE_FIELD] = entry.FromDate; if(entry.ApprovedOn.Equals(new DateTime())) newRow[tblLeaveDetails.APPROVEDON_FIELD] = DBNull.Value; else newRow[tblLeaveDetails.APPROVEDON_FIELD] = entry.ApprovedOn; newRow[tblLeaveDetails.APPROVEDDAYS_FIELD] = entry.ApprovedDays; if(entry.CreatedOn.Equals(new DateTime())) newRow[tblLeaveDetails.CREATEDON_FIELD] = DBNull.Value; else newRow[tblLeaveDetails.CREATEDON_FIELD] = entry.CreatedOn; newRow[tblLeaveDetails.CREATEDBYID_FIELD] = entry.CreatedByID; if(entry.ModifiedOn.Equals(new DateTime())) newRow[tblLeaveDetails.MODIFIEDON_FIELD] = DBNull.Value; else newRow[tblLeaveDetails.MODIFIEDON_FIELD] = entry.ModifiedOn; newRow[tblLeaveDetails.MODIFIEDBYID_FIELD] = entry.ModifiedByID; dt.Rows.Add(newRow); i++; } //if(adding): Commented out at the moment. KS 28th Aug 2012 return tblObj.AddToTable(dt); //else //return tblObj.UpdateTable(dt); }
public static int Save(BOLeaveDetailsList entryList, bool adding) { tblLeaveDetails tblObj = new tblLeaveDetails(); DataTable dt = tblObj.Table(); int i = 0; foreach (BOLeaveDetails entry in entryList) { DataRow newRow = tblObj.Table().NewRow(); newRow[tblLeaveDetails.EMPLOYEEID_FIELD] = entry.EmployeeID; newRow[tblLeaveDetails.TOTALCASUALLEAVE_FIELD] = entry.TotalCasualLeave; newRow[tblLeaveDetails.TOTALSICKLEAVE_FIELD] = entry.TotalSickLeave; newRow[tblLeaveDetails.LEAVETYPE_FIELD] = entry.LeaveType; newRow[tblLeaveDetails.ISAPPROVED_FIELD] = entry.IsApproved; newRow[tblLeaveDetails.APPROVEDBYID_FIELD] = entry.ApprovedByID; if (entry.ToDate.Equals(new DateTime())) { newRow[tblLeaveDetails.TODATE_FIELD] = DBNull.Value; } else { newRow[tblLeaveDetails.TODATE_FIELD] = entry.ToDate; } if (entry.FromDate.Equals(new DateTime())) { newRow[tblLeaveDetails.FROMDATE_FIELD] = DBNull.Value; } else { newRow[tblLeaveDetails.FROMDATE_FIELD] = entry.FromDate; } if (entry.ApprovedOn.Equals(new DateTime())) { newRow[tblLeaveDetails.APPROVEDON_FIELD] = DBNull.Value; } else { newRow[tblLeaveDetails.APPROVEDON_FIELD] = entry.ApprovedOn; } newRow[tblLeaveDetails.APPROVEDDAYS_FIELD] = entry.ApprovedDays; if (entry.CreatedOn.Equals(new DateTime())) { newRow[tblLeaveDetails.CREATEDON_FIELD] = DBNull.Value; } else { newRow[tblLeaveDetails.CREATEDON_FIELD] = entry.CreatedOn; } newRow[tblLeaveDetails.CREATEDBYID_FIELD] = entry.CreatedByID; if (entry.ModifiedOn.Equals(new DateTime())) { newRow[tblLeaveDetails.MODIFIEDON_FIELD] = DBNull.Value; } else { newRow[tblLeaveDetails.MODIFIEDON_FIELD] = entry.ModifiedOn; } newRow[tblLeaveDetails.MODIFIEDBYID_FIELD] = entry.ModifiedByID; dt.Rows.Add(newRow); i++; } //if(adding): Commented out at the moment. KS 28th Aug 2012 return(tblObj.AddToTable(dt)); //else //return tblObj.UpdateTable(dt); }
public static int Save(BOLeaveDetails entry, bool adding) { tblLeaveDetails tblObj = new tblLeaveDetails(); DataRow newRow = tblObj.Table().NewRow(); newRow[tblLeaveDetails.LEAVEREQUESTID_FIELD] = entry.LeaveRequestID; newRow[tblLeaveDetails.EMPLOYEEID_FIELD] = entry.EmployeeID; newRow[tblLeaveDetails.TOTALCASUALLEAVE_FIELD] = entry.TotalCasualLeave; newRow[tblLeaveDetails.TOTALSICKLEAVE_FIELD] = entry.TotalSickLeave; newRow[tblLeaveDetails.LEAVETYPE_FIELD] = entry.LeaveType; newRow[tblLeaveDetails.ISAPPROVED_FIELD] = entry.IsApproved; newRow[tblLeaveDetails.APPROVEDBYID_FIELD] = entry.ApprovedByID; if(entry.ToDate.Equals(new DateTime())) newRow[tblLeaveDetails.TODATE_FIELD] = DBNull.Value; else newRow[tblLeaveDetails.TODATE_FIELD] = entry.ToDate; if(entry.FromDate.Equals(new DateTime())) newRow[tblLeaveDetails.FROMDATE_FIELD] = DBNull.Value; else newRow[tblLeaveDetails.FROMDATE_FIELD] = entry.FromDate; if(entry.ApprovedOn.Equals(new DateTime())) newRow[tblLeaveDetails.APPROVEDON_FIELD] = DBNull.Value; else newRow[tblLeaveDetails.APPROVEDON_FIELD] = entry.ApprovedOn; newRow[tblLeaveDetails.APPROVEDDAYS_FIELD] = entry.ApprovedDays; if(entry.CreatedOn.Equals(new DateTime())) newRow[tblLeaveDetails.CREATEDON_FIELD] = DBNull.Value; else newRow[tblLeaveDetails.CREATEDON_FIELD] = entry.CreatedOn; newRow[tblLeaveDetails.CREATEDBYID_FIELD] = entry.CreatedByID; if(entry.ModifiedOn.Equals(new DateTime())) newRow[tblLeaveDetails.MODIFIEDON_FIELD] = DBNull.Value; else newRow[tblLeaveDetails.MODIFIEDON_FIELD] = entry.ModifiedOn; newRow[tblLeaveDetails.MODIFIEDBYID_FIELD] = entry.ModifiedByID; if(adding) return tblObj.AddToTable(newRow); else return tblObj.UpdateTable(newRow); }
public static int Save(BOLeaveDetails entry, bool adding) { tblLeaveDetails tblObj = new tblLeaveDetails(); DataRow newRow = tblObj.Table().NewRow(); newRow[tblLeaveDetails.LEAVEREQUESTID_FIELD] = entry.LeaveRequestID; newRow[tblLeaveDetails.EMPLOYEEID_FIELD] = entry.EmployeeID; newRow[tblLeaveDetails.TOTALCASUALLEAVE_FIELD] = entry.TotalCasualLeave; newRow[tblLeaveDetails.TOTALSICKLEAVE_FIELD] = entry.TotalSickLeave; newRow[tblLeaveDetails.LEAVETYPE_FIELD] = entry.LeaveType; newRow[tblLeaveDetails.ISAPPROVED_FIELD] = entry.IsApproved; newRow[tblLeaveDetails.APPROVEDBYID_FIELD] = entry.ApprovedByID; if (entry.ToDate.Equals(new DateTime())) { newRow[tblLeaveDetails.TODATE_FIELD] = DBNull.Value; } else { newRow[tblLeaveDetails.TODATE_FIELD] = entry.ToDate; } if (entry.FromDate.Equals(new DateTime())) { newRow[tblLeaveDetails.FROMDATE_FIELD] = DBNull.Value; } else { newRow[tblLeaveDetails.FROMDATE_FIELD] = entry.FromDate; } if (entry.ApprovedOn.Equals(new DateTime())) { newRow[tblLeaveDetails.APPROVEDON_FIELD] = DBNull.Value; } else { newRow[tblLeaveDetails.APPROVEDON_FIELD] = entry.ApprovedOn; } newRow[tblLeaveDetails.APPROVEDDAYS_FIELD] = entry.ApprovedDays; if (entry.CreatedOn.Equals(new DateTime())) { newRow[tblLeaveDetails.CREATEDON_FIELD] = DBNull.Value; } else { newRow[tblLeaveDetails.CREATEDON_FIELD] = entry.CreatedOn; } newRow[tblLeaveDetails.CREATEDBYID_FIELD] = entry.CreatedByID; if (entry.ModifiedOn.Equals(new DateTime())) { newRow[tblLeaveDetails.MODIFIEDON_FIELD] = DBNull.Value; } else { newRow[tblLeaveDetails.MODIFIEDON_FIELD] = entry.ModifiedOn; } newRow[tblLeaveDetails.MODIFIEDBYID_FIELD] = entry.ModifiedByID; if (adding) { return(tblObj.AddToTable(newRow)); } else { return(tblObj.UpdateTable(newRow)); } }