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); } }