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