public PayDesignationDC LoadByPrimaryKey(DBConnection Connection, string Code)
{
PayDesignationDC objPayDesignation = new PayDesignationDC();
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 PayDesignationDC FillObject(IDataReader reader)
{
PayDesignationDC objPayDesignation = null;
if (reader != null && reader.Read())
{
objPayDesignation = new PayDesignationDC();
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);
}
public IHttpActionResult Delete([FromBody] PayDesignationDC objUsers)
{
PayDesignationBL objUser = new PayDesignationBL();
List <EXCEPTIONDC> lstException = new List <EXCEPTIONDC>();
List <PayDesignationDC> list = new List <PayDesignationDC>();
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));
}
}
private int Update(DBConnection Connection, PayDesignationDC objPayDesignation)
{
int updateCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_PayDesignationsUpdate");
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_Description", DbType.String, objPayDesignation.Description);
dbCommandWrapper.AddInParameter("p_SortOrder", DbType.Int32, objPayDesignation.SortOrder);
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);
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 PayDesignationDC LoadByPrimaryKey(string Code)
{
DBConnection objConnection = new DBConnection();
PayDesignationDA objPayDesignationDA = new PayDesignationDA();
PayDesignationDC objPayDesignationDC = null;
try
{
objConnection.Open(false);
objPayDesignationDC = objPayDesignationDA.LoadByPrimaryKey(objConnection, Code);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objPayDesignationDC);
}
private PayDesignationDC FillObject(DataRow row)
{
PayDesignationDC objPayDesignation = null;
objPayDesignation = new PayDesignationDC();
objPayDesignation.Code = row["Code"].ToString();
objPayDesignation.Name = row["Name"].ToString();
objPayDesignation.Description = row["Description"].ToString();
objPayDesignation.SortOrder = row["SortOrder"] == DBNull.Value ? null : (int?)row["SortOrder"];
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"];
return(objPayDesignation);
}
private int Delete(DBConnection Connection, PayDesignationDC objPayDesignation)
{
int deleteCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_PayDesignationsDelete");
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);
}
public IHttpActionResult postDesignation([FromBody] PayDesignationDC payDesignation)
{
//List<EXCEPTIONDC> lstException = new List<EXCEPTIONDC>();
try
{
var bl = new PayDesignationBL();
PayDesignationBL objUser = new PayDesignationBL();
PayDesignationDC oldObj = new PayDesignationDC();
//get Object before saving
//oldObj = objUser.LoadByPrimaryKey(PayDesignationDC.Code);
List <PayDesignationDC> list = new List <PayDesignationDC>();
list.Add(payDesignation);
int UpdatedCount = 0;
if (payDesignation.Code != null && payDesignation.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);
}
}
