public PayAdvanceDC LoadByPrimaryKey(DBConnection Connection, string ID)
{
PayAdvanceDC objPayDesignation = new PayAdvanceDC();
StringBuilder sql = new StringBuilder();
sql.Append("proc_PayDesignationsLoadByPrimaryKey");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_ID", DbType.String, ID);
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 PayAdvanceDC FillObject(DataRow row)
{
PayAdvanceDC objPayDesignation = null;
objPayDesignation = new PayAdvanceDC();
objPayDesignation.ID = Convert.ToInt32(row["ID"]);
objPayDesignation.EmpCode = row["EmpCode"].ToString();
objPayDesignation.Date = row["Date"] == DBNull.Value ? null : (DateTime?)row["Date"];
objPayDesignation.Advance = Convert.ToInt16(row["Advance"]);
objPayDesignation.Description = row["Description"].ToString();
objPayDesignation.Month = Convert.ToInt16(row["Month"]);
objPayDesignation.Year = Convert.ToInt16(row["Year"]);
objPayDesignation.NoOfInst = Convert.ToInt16(row["NoOfInst"]);
objPayDesignation.EffDate = row["EffDate"] == DBNull.Value ? null : (DateTime?)row["EffDate"];
objPayDesignation.PaidAmount = Convert.ToInt16(row["PaidAmount"]);
objPayDesignation.InsAmount = Convert.ToInt16(row["InsAmount"]);
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"]);
if (row["IsSync"] != DBNull.Value)
{
objPayDesignation.IsSync = Convert.ToBoolean(row["IsSync"]);
}
objPayDesignation.RowState = row["RowState"] == DBNull.Value ? null : Convert.ToString(row["RowState"]);
objPayDesignation.SyncDate = row["SyncDate"] == DBNull.Value ? null : (DateTime?)row["SyncDate"];
objPayDesignation.CompanyID = row["CompanyID"] == DBNull.Value ? null : (int?)row["CompanyID"];
objPayDesignation.isLoan = Convert.ToBoolean(row["isLoan"]);
return(objPayDesignation);
}
private PayAdvanceDC FillObject(IDataReader reader)
{
PayAdvanceDC objPayDesignation = null;
if (reader != null && reader.Read())
{
objPayDesignation = new PayAdvanceDC();
objPayDesignation.EmpCode = reader["EmpCode"].ToString();
objPayDesignation.Date = reader["Date"] == DBNull.Value ? null : (DateTime?)reader["Date"];
objPayDesignation.Advance = Convert.ToInt16(reader["Advance"]);
objPayDesignation.Description = reader["Remarks"].ToString();
objPayDesignation.Month = Convert.ToInt16(reader["Month"]);
objPayDesignation.Year = Convert.ToInt16(reader["Year"]);
objPayDesignation.NoOfInst = Convert.ToInt16(reader["NoOfInst"]);
objPayDesignation.EffDate = reader["EffDate"] == DBNull.Value ? null : (DateTime?)reader["EffDate"];
objPayDesignation.PaidAmount = Convert.ToInt16(reader["PaidAmount"]);
objPayDesignation.InsAmount = Convert.ToInt16(reader["InsAmount"]);
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.IsSync = Convert.ToBoolean(reader["IsSync"]);
objPayDesignation.RowState = Convert.ToString(reader["RowState"]);
objPayDesignation.SyncDate = reader["SyncDate"] == DBNull.Value ? null : (DateTime?)reader["SyncDate"];
objPayDesignation.CompanyID = Convert.ToInt32(reader["CompanyID"]);
objPayDesignation.isLoan = Convert.ToBoolean(reader["isLoan"]);
reader.Close();
reader.Dispose();
}
return(objPayDesignation);
}
private PayAdvanceDC FillObjectEmployee(DataRow row)
{
PayAdvanceDC objPayDesignation = null;
objPayDesignation = new PayAdvanceDC();
objPayDesignation.EmpCode = row["EmpCode"].ToString();
objPayDesignation.Name = row["Name"].ToString();
return(objPayDesignation);
}
private int Update(DBConnection Connection, PayAdvanceDC objPayDesignation)
{
int updateCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_PayAdvanceUpdate");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_ID", DbType.String, objPayDesignation.ID);
dbCommandWrapper.AddInParameter("p_EmpCode", DbType.String, objPayDesignation.EmpCode);
dbCommandWrapper.AddInParameter("p_Date", DbType.DateTime, objPayDesignation.Date);
dbCommandWrapper.AddInParameter("p_Advance", DbType.DateTime, objPayDesignation.Advance);
dbCommandWrapper.AddInParameter("p_Description", DbType.String, objPayDesignation.Description);
dbCommandWrapper.AddInParameter("p_Month", DbType.DateTime, objPayDesignation.Month);
dbCommandWrapper.AddInParameter("p_Year", DbType.DateTime, objPayDesignation.Year);
dbCommandWrapper.AddInParameter("p_NoOfInst", DbType.Int16, objPayDesignation.NoOfInst);
dbCommandWrapper.AddInParameter("p_EffDate", DbType.String, objPayDesignation.EffDate);
dbCommandWrapper.AddInParameter("p_PaidAmount", DbType.DateTime, objPayDesignation.PaidAmount);
dbCommandWrapper.AddInParameter("p_InsAmount", DbType.DateTime, objPayDesignation.InsAmount);
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_IsSync", DbType.Boolean, objPayDesignation.IsSync);
dbCommandWrapper.AddInParameter("p_RowState", DbType.String, objPayDesignation.RowState);
dbCommandWrapper.AddInParameter("p_SyncDate", DbType.DateTime, objPayDesignation.SyncDate);
dbCommandWrapper.AddInParameter("p_CompanyID", DbType.Int32, objPayDesignation.CompanyID);
dbCommandWrapper.AddInParameter("p_isLoan", DbType.Int32, objPayDesignation.isLoan);
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] PayAdvanceDC objUsers)
{
PayAdvanceBL objUser = new PayAdvanceBL();
List <EXCEPTIONDC> lstException = new List <EXCEPTIONDC>();
List <PayAdvanceDC> list = new List <PayAdvanceDC>();
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 PayAdvanceDC LoadByPrimaryKey(string ID)
{
DBConnection objConnection = new DBConnection();
PayAdvanceDA objPayAdvanceDA = new PayAdvanceDA();
PayAdvanceDC objPayAdvanceDC = null;
try
{
objConnection.Open(false);
objPayAdvanceDC = objPayAdvanceDA.LoadByPrimaryKey(objConnection, ID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objPayAdvanceDC);
}
private int Delete(DBConnection Connection, PayAdvanceDC objPayDesignation)
{
int deleteCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_PayAdvanceDelete");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_ID", DbType.String, objPayDesignation.ID);
if (Connection.Transaction != null)
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(deleteCount);
}
public IHttpActionResult postShifts([FromBody] PayAdvanceDC payDepartment)
{
//List<EXCEPTIONDC> lstException = new List<EXCEPTIONDC>();
try
{
var bl = new PayAdvanceBL();
PayAdvanceBL objUser = new PayAdvanceBL();
PayAdvanceDC oldObj = new PayAdvanceDC();
//get Object before saving
//oldObj = objUser.LoadByPrimaryKey(PayLeavesDC.Code);
List <PayAdvanceDC> list = new List <PayAdvanceDC>();
list.Add(payDepartment);
int UpdatedCount = 0;
if (payDepartment.ID != null && payDepartment.ID > 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);
}
}
