// POST api/leavedetails
public string Post([FromBody] BOLeaveDetails LeaveDetailsObj)
{
try
{
int id = LeaveDetailsObj != null ? LeaveDetailsObj.EmployeeID : 0;
int count = BLLLeaveDetails.Save(LeaveDetailsObj, id > 0 ? true : false);
return(count > 0 ? "Record saved successfully" : "There is a problem while saving record");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public static BOLeaveDetails GetItem(Int32 id)
{
BOLeaveDetails itemObj = null;
tblLeaveDetails tblObj = new tblLeaveDetails();
DataTable dt = tblObj.GetAllData(tblLeaveDetails.PRIMARYKEY_FIELD1 + " = " + id);
if (dt.Rows.Count > 1)
{
throw new Exception("More than one row returned");
}
if (dt.Rows.Count == 1)
{
itemObj = FillDataRecord(dt.Rows[0]);
}
return(itemObj);
}
public static BOLeaveDetails GetLeaveDetailByEmpID(Int32 id)
{
BOLeaveDetails itemObj = null;
DataSet ds = spGetLeaveByEmployeeID.ExecuteDataset(id);
if (ds.Tables[0].Rows.Count > 1)
{
throw new Exception("More than one row returned");
}
if (ds.Tables[0].Rows.Count == 1)
{
itemObj = FillDataRecord(ds.Tables[0].Rows[0]);
}
return(itemObj);
}
private static BOLeaveDetails FillDataRecord(DataRow dr)
{
BOLeaveDetails itemObj = new BOLeaveDetails();
if (dr["LeaveRequestID"] != DBNull.Value)
{
itemObj.LeaveRequestID = Int32.Parse(dr["LeaveRequestID"].ToString());
}
if (dr["EmployeeID"] != DBNull.Value)
{
itemObj.EmployeeID = Int32.Parse(dr["EmployeeID"].ToString());
}
if (dr["TotalCasualLeave"] != DBNull.Value)
{
itemObj.TotalCasualLeave = Int32.Parse(dr["TotalCasualLeave"].ToString());
}
if (dr["TotalSickLeave"] != DBNull.Value)
{
itemObj.TotalSickLeave = Int32.Parse(dr["TotalSickLeave"].ToString());
}
if (dr["LeaveType"] != DBNull.Value)
{
itemObj.LeaveType = Boolean.Parse(dr["LeaveType"].ToString());
}
if (dr["IsApproved"] != DBNull.Value)
{
itemObj.IsApproved = Boolean.Parse(dr["IsApproved"].ToString());
}
if (dr["ApprovedByID"] != DBNull.Value)
{
itemObj.ApprovedByID = dr["ApprovedByID"].ToString();
}
if (dr["ToDate"] != DBNull.Value)
{
itemObj.ToDate = DateTime.Parse(dr["ToDate"].ToString());
}
if (dr["FromDate"] != DBNull.Value)
{
itemObj.FromDate = DateTime.Parse(dr["FromDate"].ToString());
}
if (dr["ApprovedOn"] != DBNull.Value)
{
itemObj.ApprovedOn = DateTime.Parse(dr["ApprovedOn"].ToString());
}
if (dr["ApprovedDays"] != DBNull.Value)
{
itemObj.ApprovedDays = Int32.Parse(dr["ApprovedDays"].ToString());
}
if (dr["CreatedOn"] != DBNull.Value)
{
itemObj.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
}
if (dr["CreatedByID"] != DBNull.Value)
{
itemObj.CreatedByID = dr["CreatedByID"].ToString();
}
if (dr["ModifiedOn"] != DBNull.Value)
{
itemObj.ModifiedOn = DateTime.Parse(dr["ModifiedOn"].ToString());
}
if (dr["ModifiedByID"] != DBNull.Value)
{
itemObj.ModifiedByID = dr["ModifiedByID"].ToString();
}
return(itemObj);
}
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 Update(BOLeaveDetails entry)
{
return(tblLeaveDetailsDBManager.Save(entry, false));
}
public static int Save(BOLeaveDetails entry)
{
return(tblLeaveDetailsDBManager.Save(entry, true));
}
public static int Save(BOLeaveDetails entry, bool adding)
{
return(tblLeaveDetailsDBManager.Save(entry, adding));
}
