public string CreateBankDetails(PropertyBo propertyBo) { var transactionStatus = new TransactionStatus(); CemexDb con = new CemexDb(); var property = BuiltPropertyDomain(propertyBo); SqlParameter[] Params = { new SqlParameter("@opReturnValue", SqlDbType.Int), //0 new SqlParameter("@Prop_Id", property.Prop_Id), //1 new SqlParameter("@Bank_Name", property.Bank_Name), //2 new SqlParameter("@Bank_Branch_Name", property.Bank_Branch_Name), //3 new SqlParameter("@Bank_Branch_Code", property.Bank_Branch_Code), //4 new SqlParameter("@Bank_IFC_code", property.Bank_IFC_code), //5 new SqlParameter("@Bank_Accnt_No", property.Bank_Accnt_No), //6 new SqlParameter("@Bank_Accnt_Name", property.Bank_Accnt_Name), //7 new SqlParameter("@Vndr_Id", property.Vndr_Id), //8 new SqlParameter("@CityID", property.City_Id), //9 new SqlParameter("@Bank_descr", "null"), //2 }; Params[0].Direction = ParameterDirection.Output; DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddBankDetails", Params); return(ds.Tables[0].Rows[0][0].ToString()); }
public TransactionStatus EditBank(PropertyBo bankBo) { var transactionStatus = new TransactionStatus(); CemexDb con = new CemexDb(); var property = BuiltPropertyDomain(bankBo); SqlParameter[] Params = { new SqlParameter("@opReturnValue", SqlDbType.Int), //0 new SqlParameter("@Bank_Name", property.Bank_Name), //2 new SqlParameter("@Bank_Branch_Name", property.Bank_Branch_Name), //3 new SqlParameter("@Bank_Branch_Code", property.Bank_Branch_Code), //4 new SqlParameter("@Bank_IFC_code", property.Bank_IFC_code), //5 new SqlParameter("@Bank_Accnt_No", property.Bank_Accnt_No), //6 new SqlParameter("@Bank_Accnt_Name", property.Bank_Accnt_Name), //7 new SqlParameter("@Vndr_Id", property.Vndr_Id), //8 new SqlParameter("@CityID", property.City_Id), //9 property.CityId new SqlParameter("@Bank_Id", property.Bank_Id), //10 new SqlParameter("PropId", property.Prop_Id) //11 }; Params[0].Direction = ParameterDirection.Output; DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateBankDetails", Params); return(transactionStatus); }
public TransactionStatus DetetePolicy(PropertyBo propertyBo) { var transactionStatus = new TransactionStatus(); CemexDb con = new CemexDb(); SqlParameter[] Params = { new SqlParameter("@Id", propertyBo.Policy_Id), //0 new SqlParameter("@opReturnValue", SqlDbType.Int), //1 }; Params[1].Direction = ParameterDirection.Output; DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "[proc_DeletePropertyPolicy]", Params); return(transactionStatus); }
public TransactionStatus Edit(PropertyBo propertyBo) { var transactionStatus = new TransactionStatus(); CemexDb con = new CemexDb(); var property = BuiltPropertyDomain(propertyBo); SqlParameter[] Params = { new SqlParameter("@opReturnValue", SqlDbType.Int), //0 new SqlParameter("@Prop_Id", property.Prop_Id), //1 new SqlParameter("@Prop_Name", property.Prop_Name), //2 new SqlParameter("@Prop_Cin_No", property.Prop_Cin_No), //3 new SqlParameter("@Prop_Addr1", property.Prop_Addr1), //4 new SqlParameter("@Prop_Addr2", property.Prop_Addr2), //5 new SqlParameter("@CityID", property.City_Id), //7 property.CityId new SqlParameter("@Prop_Star_Rating", property.Prop_Star_Rating), //12 new SqlParameter("@Prop_GPS_Pos", property.Prop_GPS_Pos), //13 new SqlParameter("@Prop_Booking_MailId", property.Prop_Booking_MailId), //14 new SqlParameter("@Prop_Booking_Mob", property.Prop_Booking_Mob), //15 new SqlParameter("@Prop_Pricing_MailId", property.Prop_Pricing_MailId), //16 new SqlParameter("@Prop_Pricing_Mob", property.Prop_Pricing_Mob), //17 new SqlParameter("@Prop_Inventory_MailId", property.Prop_Inventory_MailId), //18 new SqlParameter("@Prop_Inventory_Mob", property.Prop_Inventory_Mob), //19 // new SqlParameter("@Image_dir", property.Image_dir),//20 new SqlParameter("@Pricing_Type", property.Pricing_Type), //19 new SqlParameter("@Prop_Type", property.Prop_Type), //19 new SqlParameter("@Prop_Overview", property.Prop_Overview), //22 new SqlParameter("@Room_Checkin", property.Room_Checkins), //22 new SqlParameter("@Room_Checkout", property.Room_Checkouts), //22 new SqlParameter("@Location_Name", property.Location_Name), //22 new SqlParameter("@City_Name", property.City_Name), //22 new SqlParameter("@State_Name", property.State_Name), //22 new SqlParameter("@Pin_Code", property.Pin_Code), //22 new SqlParameter("@TripAdvi", property.TripAdv), //22 }; Params[0].Direction = ParameterDirection.Output; DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateProperty", Params); return(transactionStatus); }
public TransactionStatus DeteteImage(PropertyBo propertyBo) { var transactionStatus = new TransactionStatus(); CemexDb con = new CemexDb(); var property = BuiltPropertyDomain(propertyBo); SqlParameter[] Params = { new SqlParameter("@Image_Id", property.Image_Id), //0 new SqlParameter("@opReturnValue", SqlDbType.Int), //4 }; Params[1].Direction = ParameterDirection.Output; DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_DeleteImage", Params); return(transactionStatus); }
public String CreateProperty(PropertyBo propertyBo) { CemexDb con = new CemexDb(); var property = BuiltPropertyDomain(propertyBo); if (property.TripAdv == null) { property.TripAdv = ""; } SqlParameter[] Params = { new SqlParameter("@Prop_Name", property.Prop_Name), //0 new SqlParameter("@Prop_Cin_No", property.Prop_Cin_No), //1 new SqlParameter("@Prop_Addr1", property.Prop_Addr1), //2 new SqlParameter("@Prop_Addr2", property.Prop_Addr2), //3 new SqlParameter("@CityID", property.City_Id), //5 new SqlParameter("@Prop_Star_Rating", property.Prop_Star_Rating), //10 new SqlParameter("@Prop_GPS_Pos", property.Prop_GPS_Pos), //11 new SqlParameter("@Prop_Booking_MailId", property.Prop_Booking_MailId), //12 new SqlParameter("@Prop_Booking_Mob", property.Prop_Booking_Mob), //13 new SqlParameter("@Prop_Pricing_MailId", property.Prop_Pricing_MailId), //14 new SqlParameter("@Prop_Pricing_Mob", property.Prop_Pricing_Mob), //15 new SqlParameter("@Prop_Inventory_MailId", property.Prop_Inventory_MailId), //16 new SqlParameter("@Prop_Inventory_Mob", property.Prop_Inventory_Mob), //17 new SqlParameter("@Vndr_Id", property.Vndr_Id), //18 new SqlParameter("@Image_dir", property.Image_dir), //19 new SqlParameter("@Pricing_Type", property.Pricing_Type), //20 new SqlParameter("@Prop_Type", property.Prop_Type), //21 new SqlParameter("@Prop_Overview", property.Prop_Overview), //22 new SqlParameter("@Room_Checkin", property.Room_Checkins), //22 new SqlParameter("@Room_Checkout", property.Room_Checkouts), //22 new SqlParameter("@Location_Name", property.Location_Name), //22 new SqlParameter("@City_Name", property.City_Name), //22 new SqlParameter("@State_Name", property.State_Name), //22 new SqlParameter("@Pin_Code", property.Pin_Code), //22 new SqlParameter("@TripAdv", property.TripAdv) //22 }; DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddProperty", Params); return(ds.Tables[0].Rows[0][0].ToString()); }
public TransactionStatus CreateFacility(PropertyBo propertyBo) { var transactionStatus = new TransactionStatus(); CemexDb con = new CemexDb(); var property = BuiltPropertyDomain(propertyBo); SqlParameter[] Params = { new SqlParameter("@Facility_Name", property.Facility_Name), //0 new SqlParameter("@Facility_Type", property.Facility_Type), //1 new SqlParameter("@Prop_Id", property.Prop_Id), //2 new SqlParameter("@opReturnValue", SqlDbType.Int), //3 }; Params[3].Direction = ParameterDirection.Output; DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddPropertyFacility", Params); return(transactionStatus); }
public TransactionStatus DeleteProperty(PropertyBo propertyBo) { var transactionStatus = new TransactionStatus(); CemexDb con = new CemexDb(); var property = BuiltPropertyDomain(propertyBo); SqlParameter[] Params = { new SqlParameter("@Prop_Id", property.Prop_Id), //0 new SqlParameter("@Prop_Approved_By", property.Prop_Approved_By), //1 new SqlParameter("@Prop_Approved_on", property.Prop_Approved_on), //2 new SqlParameter("@Prop_Expires_on", property.Prop_Expires_on), //3 new SqlParameter("@opReturnValue", SqlDbType.Int), //4 }; Params[4].Direction = ParameterDirection.Output; DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_DeleteProperty", Params); return(transactionStatus); }
public TransactionStatus EditPolicy(PropertyBo propertyBo) { var transactionStatus = new TransactionStatus(); CemexDb con = new CemexDb(); var property = BuiltPropertyDomain(propertyBo); SqlParameter[] Params = { new SqlParameter("@Policy_Id", property.Policy_Id), //2 new SqlParameter("@Policy_Name", property.Policy_Name), //0 new SqlParameter("@Policy_descr", property.Policy_descr), //1 new SqlParameter("@opReturnValue", SqlDbType.Int), //0 }; Params[3].Direction = ParameterDirection.Output; DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "[proc_UpdatePropertyPolicies]", Params); // ds.Locale = CultureInfo.InvariantCulture; return(transactionStatus); }
private Property BuiltPropertyDomain(PropertyBo propertyBo) { return((Property) new Property().InjectFrom(propertyBo)); }