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