public JsonResult Add(DriverViewModel model)
{
if (ModelState.IsValid)
{
var User = SessionManager.GetSessionUser();
var UserID = User.Id;
var driverDetail = GBContext.DriverDetails.Where(m => m.PhoneNumber == model.PhoneNumber ||
(m.LicenceNo != null && m.LicenceNo != String.Empty && m.LicenceNo == model.LicenceNo)).FirstOrDefault();
if (driverDetail == null)
{
DriverDetail driver = new DriverDetail();
driver.FirstName = model.FirstName;
driver.LastName = model.LastName;
driver.PhoneNumber = model.PhoneNumber;
driver.Pincode = model.Pincode;
driver.LicenceTypeID = model.LicenceType;
driver.LicenceNo = model.LicenceNo;
driver.Uber = model.Uber;
driver.Ola = model.Ola;
driver.IsReferred = model.IsReferred;
driver.UserID = UserID;
driver.CreatedOn = DateTime.Now;
driver.LastUpdatedOn = DateTime.Now;
driver.DriverStatusID = 1;//for new entry its always 1
driver.ExpectedSalary = model.ExpectedSalary;
driver.CityID = model.CityID;
if (User.OrganizationID == (int)Constants.Organizations.Uber)
{
driver.isVisibletoUber = true;
}
else
{
driver.isVisibletoUber = false;
}
GBContext.DriverDetails.Add(driver);
//GBContext.DriverDetailsActivityLogs.Add(Mapper.Map<DriverDetail, DriverDetailsActivityLog>(driver));
if (GBContext.SaveChanges() > 0)
{
return(Json(new { Success = true, Message = "New driver added successfully." }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Success = false, Message = "Failed to add driver." }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { Success = false, Message = "Driver details(phone number or license number) already exists! Please try with some other driver." }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { Success = false, Message = "Please check your inputs and try again." }, JsonRequestBehavior.AllowGet));
}
public object AddDriver(DriverDetail driverDetail)
{
int count = db.DriverDetails.ToList().Where(driver => driver.DID == driverDetail.DID).Count();
if (count == 1)
{
return("This Driver Already Exists");
}
else
{
db.proc_AddDriver(driverDetail.FirstName, driverDetail.LastName, driverDetail.PhoneNumber);
db.SaveChanges();
return("Driver Registered Successfully");
}
}
public IHttpActionResult UpdateDriver(DriverDetail changedetail)
{
var driver = new BusReservationEntities1();
string result = null;
try
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid Model"));
}
{
var existingdriver = driver.DriverDetails.Where(p => p.DID == changedetail.DID).FirstOrDefault <DriverDetail>();
if (existingdriver != null)
{
existingdriver.DID = changedetail.DID;
existingdriver.FirstName = changedetail.FirstName;
existingdriver.LastName = changedetail.LastName;
existingdriver.PhoneNumber = changedetail.PhoneNumber;
driver.SaveChanges();
}
else
{
return(Ok(result));
}
}
return(Ok("Data Updated"));
}
catch (Exception e)
{
var error = driver.GetValidationErrors();
return(Ok(result));
}
}
public Int32 InsertDriverDetail(DriverDetail DriverDetail)
{
int outResult = 0;
DriverDetailsDLL objDriverDetail = null;
try
{
objDriverDetail = new DriverDetailsDLL();
outResult = objDriverDetail.InsertDriverDetail(DriverDetail);
}
catch
{
throw;
}
return outResult;
}
/// <summary>
/// To Update Driver
/// </summary>
/// <param name="DriverCode"></param>
/// <param name="IsActive"></param>
/// <returns></returns>
public Int32 UpdateDriverDetail(DriverDetail DriverDetail)
{
Int32 outResult = 0;
DriverDetailsDLL objDriverDetail = null;
try
{
objDriverDetail = new DriverDetailsDLL();
outResult = objDriverDetail.UpdateDriverDetail(DriverDetail);
}
catch
{
throw;
}
return outResult;
}
public ActionResult Edit(DriverViewModel driverDetail)
{
if (ModelState.IsValid)
{
DriverDetail dbDriverDetail = (DriverDetail)GBContext.DriverDetails.Where(m => m.DriverDetailID == driverDetail.DriverDetailID).FirstOrDefault();
//check ph number
if (dbDriverDetail.PhoneNumber != driverDetail.PhoneNumber)
{
var User = GBContext.DriverDetails.Where(m => m.PhoneNumber == driverDetail.PhoneNumber).FirstOrDefault();
if (User != null)
{
return(Json(new { Success = false, Message = "Phone number already exists!" }, JsonRequestBehavior.AllowGet));
}
}
//check license number
if (driverDetail.LicenceNo != null && driverDetail.LicenceNo != String.Empty && dbDriverDetail.LicenceNo != driverDetail.LicenceNo)
{
var User = GBContext.DriverDetails.Where(m => m.LicenceNo == driverDetail.LicenceNo).FirstOrDefault();
if (User != null)
{
return(Json(new { Success = false, Message = "License number already exists!" }, JsonRequestBehavior.AllowGet));
}
}
dbDriverDetail.FirstName = driverDetail.FirstName;
dbDriverDetail.LastName = driverDetail.LastName;
dbDriverDetail.PhoneNumber = driverDetail.PhoneNumber;
dbDriverDetail.Pincode = driverDetail.Pincode;
dbDriverDetail.LicenceTypeID = driverDetail.LicenceType;
dbDriverDetail.DriverStatusID = driverDetail.Status;
dbDriverDetail.LicenceNo = driverDetail.LicenceNo;
dbDriverDetail.ExpectedSalary = driverDetail.ExpectedSalary;
dbDriverDetail.LastUpdatedBy = SessionManager.GetSessionUser().Id;
dbDriverDetail.LastUpdatedOn = DateTime.Now;
if (driverDetail.FollowUpOn != null && driverDetail.FollowUpOn != String.Empty)
{
dbDriverDetail.FollowUpOn = DateTime.ParseExact(driverDetail.FollowUpOn.ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
dbDriverDetail.FollowUpNotes = driverDetail.FollowUpNotes;
if (driverDetail.NextFollowUp != null && driverDetail.NextFollowUp != String.Empty)
{
dbDriverDetail.NextFollowUp = DateTime.ParseExact(driverDetail.NextFollowUp.ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
if (driverDetail.Status == (int)Constants.EnumDriverStatus.Attached)
{
dbDriverDetail.AttachedOn = DateTime.Now;
}
else if (driverDetail.Status == (int)Constants.EnumDriverStatus.PartnerMatched)
{
dbDriverDetail.PartnerMatchedOn = DateTime.Now;
}
else if (driverDetail.Status == (int)Constants.EnumDriverStatus.CompletedFirstTrip)
{
dbDriverDetail.CompletedFirstTripOn = DateTime.Now;
}
dbDriverDetail.Ola = driverDetail.Ola;
dbDriverDetail.Uber = driverDetail.Uber;
//GBContext.DriverDetailsActivityLogs.Add(Mapper.Map<DriverDetail, DriverDetailsActivityLog>(dbDriverDetail));
if (GBContext.SaveChanges() > 0)
{
return(Json(new { Success = true, Message = "Driver Details updated Successfully!!" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Success = false, Message = "Error in updating driver details.Please try again later." }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { Success = false, Message = "Please check your inputs and try again." }, JsonRequestBehavior.AllowGet));
}
public static Int32 UpdateDriver(DriverDetail DriverDetail)
{
DriverDetailsBLL objDriverDetailBLL = null;
Int32 outResult = 0;
try
{
objDriverDetailBLL = new DriverDetailsBLL();
Common objCommon = new Common();
DriverDetail.ModifyBy = objCommon.GetCurrentUserName();
//DriverDetail.IsActive = true;
outResult = objDriverDetailBLL.UpdateDriverDetail(DriverDetail);
}
catch (Exception ex)
{
Common.WriteError(ex);
}
finally
{
objDriverDetailBLL = null;
}
return outResult;
}
public static int InsertDriverDetail(DriverDetail DriverDetail)
{
DriverDetailsBLL objDriverDetailBLL = null;
int outResult = 0;
try
{
objDriverDetailBLL = new DriverDetailsBLL();
Common objCommon = new Common();
DriverDetail.CreatedBy = objCommon.GetCurrentUserName();
DriverDetail.IsActive = true;
outResult = objDriverDetailBLL.InsertDriverDetail(DriverDetail);
}
catch(Exception ex)
{
Common.WriteError(ex);
}
finally
{
objDriverDetailBLL = null;
}
return outResult;
}
public async Task <IHttpActionResult> Register([FromBody] RegisterModel model)
{
var errors = new List <string>();
if (ModelState.IsValid)
{
try
{
if (model.RoleId == (int)UserRole.Driver)
{
if (string.IsNullOrWhiteSpace(model.Vehicle))
{
errors.Add("Vehicle name is required");
}
if (model.Contact.Length < 11)
{
errors.Add("Contact is required");
}
}
if (model.RoleId == (int)UserRole.Customer)
{
}
if (string.IsNullOrWhiteSpace(model.FirstName))
{
errors.Add("First name is required");
}
if (string.IsNullOrWhiteSpace(model.LastName))
{
errors.Add("Last name is required");
}
if (string.IsNullOrWhiteSpace(model.Email))
{
errors.Add("EmailId is required");
}
if (errors.Count > 0)
{
return(Json(new { status = errors.Count == 0, errors }));
}
WebSecurity.CreateUserAndAccount(model.Email,
new Security(model.Password).Encrypt(),
propertyValues: new
{
FirstName = model.FirstName,
LastName = model.LastName,
RoleId = model.RoleId,
RowState = (int)RowState.Created,
HasImage = false,
});
int driverId = context.UserProfile.First(a => a.EmailId == model.Email).UserId;
if (model.RoleId == (int)UserRole.Customer)
{
}
else if (model.RoleId == (int)UserRole.Driver)
{
var driver = new DriverDetail();
driver.DriverId = driverId;
driver.VehicleNumber = model.Vehicle;
driver.Contact = model.Contact;
driver.StatusId = (int)DriverStatus.LoggedOut;
driver.IsLoaded = false;
driver.IsAccepted = false;
driver.CurrentLatitude = "0.0";
driver.CurrentLongitude = "0.0";
context.DriverDetail.Add(driver);
try
{
await context.SaveChangesAsync();
}
catch (System.Exception ex)
{
throw;
}
}
}
catch (MembershipCreateUserException e)
{
errors.Add(e.StatusCode.ToString());
}
}
return(Json(new { status = errors.Count == 0, errors }));
}
/// <summary>
/// Method to Update Driver DETAIL
/// </summary>
/// <returns></returns>
///
public Int32 UpdateDriverDetail(DriverDetail DriverDetail)
{
ObjSqlHelper = new SqlHelper.SqlHelper();
SqlParameter[] oPara =
{
new SqlParameter("@DriverId",SqlDbType.Int),
new SqlParameter("@DriverName",SqlDbType.VarChar),
new SqlParameter("@DriverCode", SqlDbType.Int),
new SqlParameter("@DCID", SqlDbType.Int),
new SqlParameter("@EmpanelDate", SqlDbType.VarChar),
new SqlParameter("@ModifBy", SqlDbType.VarChar),
new SqlParameter("@IsActive", SqlDbType.Bit),
new SqlParameter("@Rval", SqlDbType.Int),
};
oPara[0].Value = DriverDetail.DriverId;
oPara[0].Size = 155;
oPara[1].Value = DriverDetail.DriverName;
oPara[1].Size = 155;
oPara[2].Value = DriverDetail.DriverCode;
oPara[2].Size = 155;
oPara[3].Value = DriverDetail.DCID;
oPara[3].Size = 255;
oPara[4].Value = DriverDetail.EmpanelDate;
oPara[4].Size = 255;
oPara[5].Value = DriverDetail.ModifyBy;
oPara[5].Size = 255;
oPara[6].Value = DriverDetail.IsActive;
oPara[6].Size = 255;
oPara[7].Direction = ParameterDirection.ReturnValue;
ObjSqlHelper.ExecNonQueryProc(ConstantsDLL.USP_UpdateDriverDetail, oPara);
return Convert.ToInt32(oPara[7].Value);
}
