//for connection string
private Policies BuiltpolicyDomain(PoliciesBo policyBo)
{
return((Policies) new Policies().InjectFrom(policyBo));
}
//create Policies
public TransactionStatus Createpolicies(PoliciesBo policyBo)
{
try
{
var transactionStatus = new TransactionStatus();
var policy = BuiltpolicyDomain(policyBo);
string time = "16:23:01";
var result = Convert.ToDateTime(time);
string testtime = result.ToString("hh:mm:ss tt", CultureInfo.CurrentCulture);
DateTime dt = new DateTime();
dt = DateTime.Now;
#region using sql helper
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
//new SqlParameter("@Type_Id", policy.Type_Id),//0
//new SqlParameter("@Room_Name", testing),//1 rooms.Room_Name
//new SqlParameter("@Room_Overview", policy.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", defaultvalue),//5 rooms.Room_Extra_Adul
//new SqlParameter("@Room_Standard_rate", defaultvalue),//6 rooms.Room_Standard_rate
//new SqlParameter("@Room_Agreed_Availability", policy.Room_Agreed_Availability),//7
//new SqlParameter("@Room_Lmk_Rate", policy.Room_Lmk_Rate),//8
//new SqlParameter("@Room_camflg",policy.Room_camflg),//9
//new SqlParameter("@Room_Checkin",testtime ),//10 rooms.Room_Checkin
//new SqlParameter("@Room_Checkout",testtime ), //11 rooms.Room_Checkout
//new SqlParameter("@Room_Grace_time", testtime), //12 rooms.Room_Grace_time
//new SqlParameter("@Room_Max_Thrshold_Disc", defaultvalue),//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 ", policy.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("@opReturnValue", value)//25
};
Params[25].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddRooms", Params);
ds.Locale = CultureInfo.InvariantCulture;
string test = Params[25].Value.ToString();
// transactionStatus.id = Convert.ToInt32(test);
#endregion
return(transactionStatus);
}
catch (Exception ex)
{
ApplicationErrorLogServices.AppException(ex);
return(null);
}
}
