//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); } }