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