public string CreateRooms(RoomsBo roomsBo)
{
try
{
var transactionStatus = new TransactionStatus();
var rooms = BuiltRoomsDomain(roomsBo);
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);
if (rooms.Room_Extra_Adul == null)
{
rooms.Room_Extra_Adul = "";
}
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 = "testingRoom";
DateTime dt = new DateTime();
dt = DateTime.Now;
string Flags = "true";
int value = 1;
int defaultvalue = 0;
//if (rooms.Room_Standard_rate != "0" || rooms.Room_Standard_rate != "" || rooms.Room_Standard_rate != null)
//{
// defaultvalue = Convert.ToInt32(rooms.Room_Standard_rate);
//}
// string RoomName =GetRoomName(rooms.Type_Id);
#region using sql helper
CemexDb con = new CemexDb();
if (rooms.Image_dir == "null" || rooms.Image_dir == null)
{
rooms.Image_dir = "/img/Room-image.png";
}
SqlParameter[] Params =
{
new SqlParameter("@opReturnValue", value), //26
new SqlParameter("@Room_Name", rooms.Room_Name), //1 rooms.Room_Name
new SqlParameter("@Room_Overview", rooms.Room_Overview), //2
new SqlParameter("@Room_Adult_occup", defaultvalue), //3 rooms.Room_Adult_occup
new SqlParameter("@Room_Child_occup", defaultvalue), //4 rooms.Room_Child_occup
new SqlParameter("@Room_Extra_Adul", rooms.Room_Extra_Adul), //5 rooms.Room_Extra_Adul
new SqlParameter("@Room_Standard_rate", Convert.ToInt32(rooms.Room_Standard_rate)), //6 rooms.Room_Standard_rate
new SqlParameter("@Room_Agreed_Availability", defaultvalue), //7
new SqlParameter("@Room_Lmk_Rate", defaultvalue), //8
new SqlParameter("@Room_camflg", defaultvalue), //9
// new SqlParameter("@Room_camflg",rooms.Room_camflg),//9
new SqlParameter("@Room_Checkin", Room_Checkintime), //10
new SqlParameter("@Room_Checkout", Room_Checkouttime), //11
new SqlParameter("@Room_Grace_time", Room_Grace_timetime), //12
new SqlParameter("@Room_Max_Thrshold_Disc", rooms.Room_Max_Thrshold_Disc), //13 rooms.Room_Max_Thrshold_Disc
new SqlParameter("@Tax_Id", defaultvalue), //14 rooms.Tax_Id
new SqlParameter("@Room_Active_flag", Flags), //15
new SqlParameter("@Image_Name ", testing), //16
new SqlParameter("@Image_dir ", rooms.Image_dir), //17
new SqlParameter("@Image_Remarks ", testing), //18
new SqlParameter("@Image_Created_By ", testing), //19
new SqlParameter("@Image_Created_on", dt), //20
new SqlParameter("@Image_Verified_By ", testing), //21
new SqlParameter("@Image_Verified_on", dt), //22
new SqlParameter("@Image_Active_From ", dt), //23
new SqlParameter("@Image_Expires_on ", dt), //24
new SqlParameter("@Prop_Id", rooms.Prop_Id), //25
};
Params[0].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddRooms", Params);
// DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddProperty", Params);
return(ds.Tables[0].Rows[0][0].ToString());
}
catch (Exception ex)
{
ApplicationErrorLogServices.AppException(ex);
return(null);
}
}
//for connection string
private Rooms BuiltRoomsDomain(RoomsBo roomsBo)
{
return((Rooms) new Rooms().InjectFrom(roomsBo));
}