/*
* id is a value of motel room and u must get id for it
*/
// POST: create a bill payment
public async Task <int> Create(BillRequest create, int id)
{
if (!IDmotel.Contains(create.IdMotel))
{
return(0);
}
if (!IDBill.Contains(create.Id))
{
var bill = new InforBill()
{
ElectricBill = create.ElectricBill,
IdInforBill = create.Id,
MonthRent = create.MonthRent,
ParkingFee = create.ParkingFee,
RoomBill = create.RoomBil,
WaterBill = create.WaterBill,
WifiBill = create.WifiBill,
IdMotel = id,
Payment = false,
DateCreate = DateTime.Now,
};
_context.InforBills.Add(bill);
return(await _context.SaveChangesAsync());
}
return(0);
}
public ReturnListBill BS_LoadListBill(string searchValue, int currPage, int recodperpage, string date_sale, int status, int id_center)
{
try
{
ReturnListBill result = new ReturnListBill();
List <InforBill> list = new List <InforBill>();
SqlConnection con = new SqlConnection();
con = Connection.Connect.GetConnect();
SqlCommand cmd = new SqlCommand("BS_LoadListBill", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@searchValue", searchValue));
cmd.Parameters.Add(new SqlParameter("@currPage", currPage));
cmd.Parameters.Add(new SqlParameter("@recodperpage", 10));
cmd.Parameters.Add(new SqlParameter("@id_center", id_center));
cmd.Parameters.Add(new SqlParameter("@date_sale", date_sale));
cmd.Parameters.Add(new SqlParameter("@status", status));
cmd.Parameters.Add("@totalCount", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
int total = Convert.ToInt16(cmd.Parameters["@totalCount"].Value);
foreach (DataRow rowItem in dt.Rows)
{
InforBill item = new InforBill();
item.RowNum = int.Parse(rowItem["RowNum"].ToString());
item.id = int.Parse(rowItem["id"].ToString());
item.type = rowItem["type"].ToString();
item.id_customer = int.Parse(rowItem["id_customer"].ToString());
item.tenKH = rowItem["tenKH"].ToString();
item.method = rowItem["method"].ToString();
item.ispay = int.Parse(rowItem["ispay"].ToString());
item.created_by = rowItem["created_by"].ToString();
item.tennguoixuat = rowItem["tennguoixuat"].ToString();
item.date_sale = (string.IsNullOrEmpty(rowItem["date_sale"].ToString())) ? "" : DateTime.Parse(rowItem["date_sale"].ToString()).ToString("dd/MM/yyyy");
item.status = int.Parse(rowItem["status"].ToString());
item.mobile = rowItem["mobile"].ToString();
item.address = rowItem["address"].ToString();
item.code = rowItem["code"].ToString();
list.Add(item);
}
result.Data = list;
result.Total = total;
return(result);
}
catch (Exception e)
{
return(null);
}
}
public static void Seed(this ModelBuilder builder)
{
var customer = new Customer
{
Address = "Ho Chi Minh",
Birthdate = Convert.ToDateTime("11/12/1998"),
Email = "*****@*****.**",
FirstName = "Thuy",
LastName = "Duong Thi Thu",
Identification = "183218131",
IDuser = "******",
PhoneNumber = "0963902609",
};
builder.Entity <Customer>().HasData(customer);
var motel = new MotelRoom
{
Area = 123,
BedRoom = 1,
idMotel = 12,
NameRoom = "Anthony's Room",
Payment = 12,
Status = true,
Toilet = 1,
};
builder.Entity <MotelRoom>().HasData(motel);
var rent = new Rent
{
IdRent = "Test2",
Start = DateTime.Today,
};
builder.Entity <Rent>().HasData(rent);
var bill = new InforBill()
{
ElectricBill = 1,
IdInforBill = "test1",
IdMotel = 12,
MonthRent = 1,
ParkingFee = 1,
RoomBill = 1,
WaterBill = 1,
WifiBill = 1,
};
builder.Entity <InforBill>().HasData(bill);
}
