//Delete DeleteRoom
public TransactionStatus DeleteRooms(RoomsEditBo roomsEditBo)
{
try
{
var transactionStatus = new TransactionStatus();
var vendor = BuiltRoomsDomain1(roomsEditBo);
CemexDb con = new CemexDb();
SqlConnection conn = con.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("dbo.Proc_DeleteUser", conn);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@Id", Convert.ToInt32(roomsEditBo.Vndr_Id));
cmd.ExecuteNonQuery();
return(transactionStatus);
}
catch (Exception ex)
{
ApplicationErrorLogServices.AppException(ex);
return(null);
}
}
private RoomsEdit BuiltRoomsDomain1(RoomsEditBo roomseditBo)
{
return((RoomsEdit) new RoomsEdit().InjectFrom(roomseditBo));
}
//Update Room
public TransactionStatus EditRooms(RoomsEditBo roomsEditBo)
{
try
{
var transactionStatus = new TransactionStatus();
var rooms = BuiltRoomsDomain1(roomsEditBo);
var Room_Checkin = Convert.ToDateTime(rooms.Room_Checkin);
var Room_Checkout = Convert.ToDateTime(rooms.Room_Checkout);
var Room_Grace_time = Convert.ToDateTime(rooms.Room_Grace_time);
string Room_Checkintime = Room_Checkin.ToString("hh:mm:ss tt", CultureInfo.CurrentCulture);
string Room_Checkouttime = Room_Checkout.ToString("hh:mm:ss tt", CultureInfo.CurrentCulture);
string Room_Grace_timetime = Room_Grace_time.ToString("hh:mm:ss tt", CultureInfo.CurrentCulture);
string testing = "";
DateTime dt = new DateTime();
dt = DateTime.Now;
string Flags = "true";
int value = 1;
int defaultvalue = 0;
#region using sql helper
CemexDb con = new CemexDb();
if (rooms.Image_dir == null)
{
rooms.Image_dir = "/img/Room-image.png";
}
SqlParameter[] Params =
{
new SqlParameter("@opReturnValue", value), //27
new SqlParameter("@Room_Id", rooms.Room_Id), //0
new SqlParameter("@Room_Name", rooms.Room_Name), //2
new SqlParameter("@Room_Overview", rooms.Room_Overview), //3
new SqlParameter("@Room_Adult_occup", defaultvalue), //4 rooms.Room_Adult_occup
new SqlParameter("@Room_Child_occup", defaultvalue), //5 rooms.Room_Child_occup
new SqlParameter("@Room_Extra_Adul", rooms.Room_Extra_Adul), //6 rooms.Room_Extra_Adul
new SqlParameter("@Room_Standard_rate", rooms.Room_Standard_rate), //7 rooms.Room_Standard_rate
//new SqlParameter("@Room_Agreed_Availability", rooms.Room_Agreed_Availability),//8
//new SqlParameter("@Room_Lmk_Rate", rooms.Room_Lmk_Rate),//9
//new SqlParameter("@Room_camflg",rooms.Room_Lmk_Rate),//10
new SqlParameter("@Room_Checkin", Room_Checkintime), //11
new SqlParameter("@Room_Checkout", Room_Checkouttime), //12
new SqlParameter("@Room_Grace_time", Room_Grace_timetime), //13
new SqlParameter("@Room_Max_Thrshold_Disc", rooms.Room_Max_Thrshold_Disc), //14 rooms.Room_Max_Thrshold_Disc
new SqlParameter("@Tax_Id", defaultvalue), //15 rooms.Tax_Id
new SqlParameter("@Room_Active_flag", Flags), //16
new SqlParameter("@Image_Id", rooms.Image_Id), //26
new SqlParameter("@Image_Name ", testing), //17
new SqlParameter("@Image_dir ", rooms.Image_dir), //18
new SqlParameter("@Image_Remarks ", testing), //19
new SqlParameter("@Image_Created_By ", testing), //20
new SqlParameter("@Image_Created_on", dt), //21
new SqlParameter("@Image_Verified_By ", testing), //22
new SqlParameter("@Image_Verified_on", dt), //23
new SqlParameter("@Image_Active_From ", dt), //24
new SqlParameter("@Image_Expires_on ", dt) //25
// new SqlParameter("@Prop_Id", rooms.Prop_Id),//27
};
Params[0].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateRooms", Params);
ds.Locale = CultureInfo.InvariantCulture;
string test = Params[0].Value.ToString();
if (test == "0")
{
transactionStatus.Status = false;
}
#endregion
return(transactionStatus);
}
catch (Exception ex)
{
ApplicationErrorLogServices.AppException(ex);
return(null);
}
}
