public bool Insert(BookingStatusDTO oBookingStatusData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Ins_BookingStatusMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sBookingStatusType", DbType.String, oBookingStatusData.BookingStatusType);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@lBookingStatusColor", DbType.Int64, oBookingStatusData.BookingStatusColor);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oBookingStatusData = null;
GF.LogError("clsBookingStatusMaster.Insert", exp.Message);
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public bool Delete(BookingStatusDTO oBookingStatusData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Del_BookingStatusMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iBookingStatusId", DbType.Int32, oBookingStatusData.BookingStatusId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oBookingStatusData = null;
GF.LogError("clsBookingStatusMaster.Delete", exp.Message);
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public BookingStatusDTO[] GetData(int BookingStatusId)
{
BookingStatusDTO[] oBookingStatusData;
oBookingStatusData = null;
DataSet ds;
string query = "select BookingStatusId, BookingStatusType, BookingStatusColor from " +
" tblBookingStatusMaster where 1=1";
if (BookingStatusId != 0)
{
query += " and BookingStatusId=" + BookingStatusId;
query += " order by BookingStatusType";
}
ds = GetDataFromDB(query);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
oBookingStatusData = new BookingStatusDTO[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
oBookingStatusData[i] = new BookingStatusDTO();
oBookingStatusData[i].BookingStatusId = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
oBookingStatusData[i].BookingStatusType = Convert.ToString(ds.Tables[0].Rows[i][1]);
//oBookingStatusData[i].BookingStatusColor = Convert.ToInt64(ds.Tables[0].Rows[i][2]);
}
}
return(oBookingStatusData);
}
