public async Task <IActionResult> Register(DeliveryBoys DeliveryBoy) { var userWithSameEmail = _dbContext.DeliveryBoys.SingleOrDefault(u => u.DBEmail == DeliveryBoy.DBEmail); if (userWithSameEmail != null) { return(BadRequest("User with this email already exists")); } var DeliveryBoyObj = new DeliveryBoys { DeliveryBoyID = Guid.NewGuid(), DBFName = DeliveryBoy.DBFName, DBLName = DeliveryBoy.DBLName, DBUserName = DeliveryBoy.DBUserName, DBPassword = DeliveryBoy.DBPassword, DBAddress = DeliveryBoy.DBAddress, DBEmail = DeliveryBoy.DBEmail, DBPhone1 = DeliveryBoy.DBPhone1, DBPhone2 = DeliveryBoy.DBPhone2, DBCityID = DeliveryBoy.DBCityID, DBRegionID = DeliveryBoy.DBRegionID, LicenseNo = DeliveryBoy.LicenseNo, VehicleID = DeliveryBoy.VehicleID }; _dbContext.DeliveryBoys.Add(DeliveryBoyObj); await _dbContext.SaveChangesAsync(); return(StatusCode(StatusCodes.Status201Created)); }
public static string GetJSon_Obj() { string ErrMsg = ""; try { List <DeliveryBoys> lstobjDB = new List <DeliveryBoys>(); { string strSql = ""; strSql = @"select DeliveryBoyID,DBFName + ' ' + DBLName as DBName,DBEmail,DBPhone1,DBPhone2,R.RegionName as DBRegion, C.CityName as DBCity, VehicleNo from DeliveryBoys DB INNER JOIN DeliveryVehicles DV on DV.VehicleID = DB.VehicleID INNER JOIN Region R ON DB.DBRegionID = R.RegionID INNER JOIN City C on C.CityID = DB.DBCityID"; if (ErrMsg != string.Empty) { clsCommon.ErrorAlertBox(ErrMsg); return(""); } using (DataTable dtList = clsDatabase.GetDT(strSql, ref ErrMsg)) { if (ErrMsg != string.Empty) { clsCommon.ErrorAlertBox(ErrMsg); return(""); } if ((dtList.Rows.Count > 0)) { rowcount = dtList.Rows.Count; foreach (DataRow r in dtList.Rows) { DeliveryBoys objManageDB = new DeliveryBoys(); objManageDB.DeliveryBoyID = r["DeliveryBoyID"].ToString().Trim(); objManageDB.DBName = r["DBName"].ToString().Trim(); objManageDB.DBEmail = r["DBEmail"].ToString().Trim(); objManageDB.DBPhone1 = r["DBPhone1"].ToString().Trim(); objManageDB.DBPhone2 = r["DBPhone2"].ToString().Trim(); objManageDB.DBRegion = r["DBRegion"].ToString().Trim(); objManageDB.DBCity = r["DBCity"].ToString().Trim(); objManageDB.VehicleNo = r["VehicleNo"].ToString().Trim(); lstobjDB.Add(objManageDB); } } } } return(JsonConvert.SerializeObject(lstobjDB)); } catch { return(""); } }