public TaskDC LoadByPrimaryKey(DBConnection Connection, string TaskID)
{
TaskDC objTask = new TaskDC();
StringBuilder sql = new StringBuilder();
sql.Append("proc_TasksLoadByPrimaryKey");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_TaskID", DbType.String, TaskID);
IDataReader reader = null;
if (Connection.Transaction != null)
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand);
}
objTask = FillObject(reader);
return(objTask);
}
private TaskDC FillObject(DataRow row)
{
TaskDC objTask = null;
objTask = new TaskDC();
objTask.TaskID = (String)row["TaskID"];
objTask.TaskDescription = (String)row["TaskDescription"];
objTask.SerialNo = (int)row["SerialNo"];
objTask.CanView = (Boolean)row["CanView"];
objTask.CanAdd = (Boolean)row["CanAdd"];
objTask.CanEdit = (Boolean)row["CanEdit"];
objTask.CanDelete = (Boolean)row["CanDelete"];
objTask.CanPrint = (Boolean)row["CanPrint"];
objTask.IsSyncReq = (Boolean)row["IsSyncReq"];
objTask.IsSync = (Boolean)row["IsSync"];
objTask.RowState = (string)row["RowState"];
objTask.AddOn = row["AddOn"] == DBNull.Value ? null : (DateTime?)row["AddOn"];
objTask.AddBy = (String)row["AddBy"];
objTask.EditOn = row["EditOn"] == DBNull.Value ? null : (DateTime?)row["EditOn"];
objTask.EditBy = (String)row["EditBy"];
objTask.SyncDate = row["SyncDate"] == DBNull.Value ? null : (DateTime?)row["SyncDate"];
objTask.CompanyID = row["CompanyID"] == DBNull.Value ? null : (int?)row["CompanyID"];
return(objTask);
}
private TaskDC FillObject(IDataReader reader)
{
TaskDC objTask = null;
if (reader != null && reader.Read())
{
objTask = new TaskDC();
objTask.TaskID = (String)reader["TaskID"];
objTask.TaskDescription = (String)reader["TaskDescription"];
objTask.SerialNo = (int)reader["SerialNo"];
objTask.CanView = (Boolean)reader["CanView"];
objTask.CanAdd = (Boolean)reader["CanAdd"];
objTask.CanEdit = (Boolean)reader["CanEdit"];
objTask.CanDelete = (Boolean)reader["CanDelete"];
objTask.CanPrint = (Boolean)reader["CanPrint"];
objTask.IsSyncReq = (Boolean)reader["IsSyncReq"];
objTask.IsSync = (Boolean)reader["IsSync"];
objTask.RowState = (String)reader["RowState"];
objTask.AddOn = reader["AddOn"] == DBNull.Value ? null : (DateTime?)reader["AddOn"];
objTask.AddBy = (String)reader["AddBy"];
objTask.EditOn = reader["EditOn"] == DBNull.Value ? null : (DateTime?)reader["EditOn"];
objTask.EditBy = (String)reader["EditBy"];
objTask.SyncDate = reader["SyncDate"] == DBNull.Value ? null : (DateTime?)reader["SyncDate"];
objTask.CompanyID = reader["CompanyID"] == DBNull.Value ? null : (int?)reader["CompanyID"];
reader.Close();
reader.Dispose();
}
return(objTask);
}
private int Update(DBConnection Connection, TaskDC objTask)
{
int updateCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_TasksUpdate");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_TaskID", DbType.String, objTask.TaskID);
dbCommandWrapper.AddInParameter("p_TaskDescription", DbType.String, objTask.TaskDescription);
dbCommandWrapper.AddInParameter("p_SerialNo", DbType.Int32, objTask.SerialNo);
dbCommandWrapper.AddInParameter("p_CanView", DbType.Boolean, objTask.CanView);
dbCommandWrapper.AddInParameter("p_CanAdd", DbType.Boolean, objTask.CanAdd);
dbCommandWrapper.AddInParameter("p_CanEdit", DbType.Boolean, objTask.CanEdit);
dbCommandWrapper.AddInParameter("p_CanDelete", DbType.Boolean, objTask.CanDelete);
dbCommandWrapper.AddInParameter("p_CanPrint", DbType.Boolean, objTask.CanPrint);
dbCommandWrapper.AddInParameter("p_IsSyncReq", DbType.Boolean, objTask.IsSyncReq);
dbCommandWrapper.AddInParameter("p_IsSync", DbType.Boolean, objTask.IsSync);
dbCommandWrapper.AddInParameter("p_RowState", DbType.String, objTask.RowState);
dbCommandWrapper.AddInParameter("p_AddOn", DbType.DateTime, objTask.AddOn);
dbCommandWrapper.AddInParameter("p_AddBy", DbType.String, objTask.AddBy);
dbCommandWrapper.AddInParameter("p_EditOn", DbType.DateTime, objTask.EditOn);
dbCommandWrapper.AddInParameter("p_EditBy", DbType.String, objTask.EditBy);
dbCommandWrapper.AddInParameter("p_SyncDate", DbType.DateTime, objTask.SyncDate);
dbCommandWrapper.AddInParameter("p_CompanyID", DbType.Int32, objTask.CompanyID);
if (Connection.Transaction != null)
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
if (updateCount == 0)
{
objTask.IsDirty = IsDirty = true;
}
return(updateCount);
}
public TaskDC LoadByPrimaryKey(string TaskID)
{
DBConnection objConnection = new DBConnection();
TaskDA objTaskDA = new TaskDA();
TaskDC objTaskDC = null;
try
{
objConnection.Open(false);
objTaskDC = objTaskDA.LoadByPrimaryKey(objConnection, TaskID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objTaskDC);
}
private int Delete(DBConnection Connection, TaskDC objTask)
{
int deleteCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_TasksDelete");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_TaskID", DbType.String, objTask.TaskID);
if (Connection.Transaction != null)
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(deleteCount);
}
