public PayShiftsDC LoadByPrimaryKey(DBConnection Connection, string Code)
{
PayShiftsDC objPayDesignation = new PayShiftsDC();
StringBuilder sql = new StringBuilder();
sql.Append("proc_PayDesignationsLoadByPrimaryKey");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_Code", DbType.String, Code);
IDataReader reader = null;
if (Connection.Transaction != null)
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand);
}
objPayDesignation = FillObject(reader);
return(objPayDesignation);
}
private PayShiftsDC FillObject(IDataReader reader)
{
PayShiftsDC objPayDesignation = null;
if (reader != null && reader.Read())
{
objPayDesignation = new PayShiftsDC();
objPayDesignation.Code = reader["Code"].ToString();
objPayDesignation.Name = reader["Name"].ToString();
// objPayDesignation.Description = reader["Description"].ToString();
//objPayDesignation.SortOrder = reader["SortOrder"] == DBNull.Value ? null : (int?)reader["SortOrder"];
objPayDesignation.IsSync = Convert.ToBoolean(reader["IsSync"]);
objPayDesignation.RowState = Convert.ToString(reader["RowState"]);
objPayDesignation.AddOn = reader["AddOn"] == DBNull.Value ? null : (DateTime?)reader["AddOn"];
objPayDesignation.AddBy = Convert.ToString(reader["AddBy"]);
objPayDesignation.EditOn = reader["EditOn"] == DBNull.Value ? null : (DateTime?)reader["EditOn"];
objPayDesignation.EditBy = Convert.ToString(reader["EditBy"]);
objPayDesignation.SyncDate = reader["SyncDate"] == DBNull.Value ? null : (DateTime?)reader["SyncDate"];
objPayDesignation.CompanyID = reader["CompanyID"] == DBNull.Value ? null : (int?)reader["CompanyID"];
reader.Close();
reader.Dispose();
}
return(objPayDesignation);
}
private int Update(DBConnection Connection, PayShiftsDC objPayDesignation)
{
int updateCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_PayShiftsUpdate");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_Code", DbType.String, objPayDesignation.Code);
dbCommandWrapper.AddInParameter("p_Name", DbType.String, objPayDesignation.Name);
dbCommandWrapper.AddInParameter("p_Start1", DbType.Time, objPayDesignation.Start1);
dbCommandWrapper.AddInParameter("p_End1", DbType.Time, objPayDesignation.End1);
dbCommandWrapper.AddInParameter("p_Split", DbType.String, objPayDesignation.Split);
dbCommandWrapper.AddInParameter("p_Start2", DbType.Time, objPayDesignation.Start2);
dbCommandWrapper.AddInParameter("p_End2", DbType.Time, objPayDesignation.End2);
dbCommandWrapper.AddInParameter("p_Relaxation", DbType.Int32, objPayDesignation.Relaxation);
dbCommandWrapper.AddInParameter("p_Duration", DbType.Int32, objPayDesignation.Duration);
dbCommandWrapper.AddInParameter("p_NextDay", DbType.Boolean, objPayDesignation.NextDay);
dbCommandWrapper.AddInParameter("p_IsSync", DbType.Boolean, objPayDesignation.IsSync);
dbCommandWrapper.AddInParameter("p_RowState", DbType.String, objPayDesignation.RowState);
dbCommandWrapper.AddInParameter("p_AddOn", DbType.DateTime, objPayDesignation.AddOn);
dbCommandWrapper.AddInParameter("p_AddBy", DbType.String, objPayDesignation.AddBy);
dbCommandWrapper.AddInParameter("p_EditOn", DbType.DateTime, objPayDesignation.EditOn);
dbCommandWrapper.AddInParameter("p_EditBy", DbType.String, objPayDesignation.EditBy);
dbCommandWrapper.AddInParameter("p_SyncDate", DbType.DateTime, objPayDesignation.SyncDate);
dbCommandWrapper.AddInParameter("p_CompanyID", DbType.Int32, objPayDesignation.CompanyID);
dbCommandWrapper.AddInParameter("p_ShiftEndingAdjustmentHours", DbType.Int32, objPayDesignation.ShiftEndingAdjustmentHours);
if (Connection.Transaction != null)
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
if (updateCount == 0)
{
objPayDesignation.IsDirty = IsDirty = true;
}
return(updateCount);
}
public IHttpActionResult Delete([FromBody] PayShiftsDC objUsers)
{
PayShiftsBL objUser = new PayShiftsBL();
List <EXCEPTIONDC> lstException = new List <EXCEPTIONDC>();
List <PayShiftsDC> list = new List <PayShiftsDC>();
list.Add(objUsers);
try
{
int IsDeleted = objUser.Delete(list);
return(Ok(IsDeleted));
}
catch (Exception ex)
{
return(new TextResult(lstException, Request, "Following PayDesignations cannot be deleted as: ", "All the other records deleted successfully.", true));
}
}
public PayShiftsDC LoadByPrimaryKey(string Code)
{
DBConnection objConnection = new DBConnection();
PayShiftsDA objPayShiftsDA = new PayShiftsDA();
PayShiftsDC objPayShiftsDC = null;
try
{
objConnection.Open(false);
objPayShiftsDC = objPayShiftsDA.LoadByPrimaryKey(objConnection, Code);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objPayShiftsDC);
}
private int Delete(DBConnection Connection, PayShiftsDC objPayDesignation)
{
int deleteCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_PayShiftsDelete");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_Code", DbType.String, objPayDesignation.Code);
if (Connection.Transaction != null)
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(deleteCount);
}
private PayShiftsDC FillObject(DataRow row)
{
PayShiftsDC objPayDesignation = null;
objPayDesignation = new PayShiftsDC();
objPayDesignation.Code = row["Code"].ToString();
objPayDesignation.Name = row["Name"].ToString();
objPayDesignation.Start1 = row["Start1"] == DBNull.Value ? null : row["Start1"].ToString();
objPayDesignation.End1 = row["End1"] == DBNull.Value ? null : row["End1"].ToString();
if (row["Split"] != DBNull.Value)
{
objPayDesignation.Split = Convert.ToBoolean(row["Split"]);
}
// objPayDesignation.Start2 = row["Start2"] == DBNull.Value ? null : (DateTime?)row["Start2"];
// objPayDesignation.End2 = row["End2"] == DBNull.Value ? null : (DateTime?)row["End2"];
objPayDesignation.Relaxation = row["Relaxation"] == DBNull.Value ? null : (int?)(row["Relaxation"]);
objPayDesignation.Duration = row["Duration"] == DBNull.Value ? null : (int?)(row["Duration"]);
if (row["NextDay"] != DBNull.Value)
{
objPayDesignation.NextDay = Convert.ToBoolean(row["NextDay"]);
}
if (row["IsSync"] != DBNull.Value)
{
objPayDesignation.IsSync = Convert.ToBoolean(row["IsSync"]);
}
objPayDesignation.RowState = row["RowState"] == DBNull.Value ? null : Convert.ToString(row["RowState"]);
objPayDesignation.AddOn = row["AddOn"] == DBNull.Value ? null : (DateTime?)row["AddOn"];
objPayDesignation.AddBy = Convert.ToString(row["AddBy"]);
//objPayDesignation.EditOn = row["EditOn"] == DBNull.Value ? null : (DateTime?)row["EditOn"];
//objPayDesignation.EditBy = Convert.ToString(row["EditBy"]);
//objPayDesignation.SyncDate = row["SyncDate"] == DBNull.Value ? null : (DateTime?)row["SyncDate"];
//objPayDesignation.CompanyID = row["CompanyID"] == DBNull.Value ? null : (int?)row["CompanyID"];
//objPayDesignation.ShiftEndingAdjustmentHours = row["ShiftEndingAdjustmentHours"] == DBNull.Value ? null : (int?)(row["ShiftEndingAdjustmentHours"]);
return(objPayDesignation);
}
public IHttpActionResult postShifts([FromBody] PayShiftsDC payDepartment)
{
//List<EXCEPTIONDC> lstException = new List<EXCEPTIONDC>();
try
{
var bl = new PayShiftsBL();
PayShiftsBL objUser = new PayShiftsBL();
PayShiftsDC oldObj = new PayShiftsDC();
//get Object before saving
//oldObj = objUser.LoadByPrimaryKey(PayShiftsDC.Code);
List <PayShiftsDC> list = new List <PayShiftsDC>();
list.Add(payDepartment);
int UpdatedCount = 0;
if (payDepartment.Code != null && payDepartment.Code.Length > 0)
{
UpdatedCount = bl.Update(list);
}
else
{
UpdatedCount = bl.Insert(list);
}
if (UpdatedCount > 0)
{
return(Ok(true));
}
return(Ok(false));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
//return new TextResult(lstException, Request);
}
}
