public JsonResult AddNewDriver([FromBody] DriversModel Driver)
{
Driver.AddedBy = Constant.GetUserID();
var Response = SQL.AddNewDriver(Driver);
return(Json(Response, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Read drivers Csv File
/// </summary>
/// <param name="strFileName"></param>
/// <returns></returns>
public static UploadDrivers ReadExecuteDriverCsvFile(string strFileName)
{
UploadDrivers validations = new UploadDrivers();
var ValidList = new List <List <DriversModel> >();
using (CsvReader reader = new CsvReader(strFileName, Encoding.Default))
{
DataTable csvTable = reader.ReadIntoDataTable();
var rangePartitioner = Partitioner.Create(0, csvTable.Rows.Count, 1000);
Parallel.ForEach(rangePartitioner, (range, loopState) =>
{
var Valid = new List <DriversModel>();
for (int i = range.Item1; i < range.Item2; i++)
{
var classObj = new DriversModel()
{
DotNumber = Convert.ToString(csvTable.Rows[i]["DotNumber"]),
FirstName = Convert.ToString(csvTable.Rows[i]["FirstName"]),
LastName = Convert.ToString(csvTable.Rows[i]["LastName"]),
LicenseState = Convert.ToString(csvTable.Rows[i]["LicenseState"]),
isActive = string.IsNullOrEmpty(Convert.ToString(csvTable.Rows[i]["isActive"])) ? "N" : (Convert.ToString(csvTable.Rows[i]["isActive"]).ToLower() == "y" || Convert.ToString(csvTable.Rows[i]["isActive"]).ToLower() == "yes") ? "Y" : "N",
LicenseNumber = Convert.ToString(csvTable.Rows[i]["LicenseNumber"]),
DOB = csvTable.Rows[i]["DOB"].ToString().Replace(" 12:00:00 AM", "")
};
Valid.Add(classObj);
}
ValidList.Add(Valid);
});
}
validations.ChunkDriverdata = ValidList;
return(validations);
}
/// <summary>
/// Tab delemited txt file reader for Drivers
/// </summary>
/// <param name="docPath"></param>
/// <returns></returns>
public static UploadDrivers ReadExecuteDelimitedDriverFile(string docPath)
{
UploadDrivers validations = new UploadDrivers();
var ValidList = new List <DriversModel>();
bool isHeader = true;
using (var file = new StreamReader(docPath))
{
string line;
while ((line = file.ReadLine()) != null)
{
if (isHeader == false)
{
var delimiters = new char[] { '\t' };
var segments = line.Split(delimiters, StringSplitOptions.None);
DriversModel driverData = new DriversModel();
driverData.DotNumber = segments[0];
driverData.FirstName = segments[1];
driverData.LastName = segments[2];
driverData.LicenseState = segments[3];
driverData.isActive = string.IsNullOrEmpty(segments[4]) ? "N" : Convert.ToString(segments[4]).ToLower().Contains('y') ? "Y" : "N";
driverData.LicenseNumber = string.IsNullOrEmpty(segments[5]) ? string.Empty : segments[5];
driverData.DOB = string.IsNullOrEmpty(segments[6]) ? string.Empty : segments[6];
ValidList.Add(driverData);
}
else
{
isHeader = false;
}
}
file.Close();
}
var ValidLists = new List <List <DriversModel> >();
var rangePartitioner = Partitioner.Create(0, ValidList.Count, 1000);
Parallel.ForEach(rangePartitioner, (range, loopState) =>
{
var Valid = new List <DriversModel>();
for (int i = range.Item1; i < range.Item2; i++)
{
var classObj = new DriversModel()
{
DotNumber = Convert.ToString(ValidList[i].DotNumber),
FirstName = Convert.ToString(ValidList[i].FirstName),
LastName = Convert.ToString(ValidList[i].LastName),
LicenseState = Convert.ToString(ValidList[i].LicenseState),
isActive = string.IsNullOrEmpty(Convert.ToString(ValidList[i].isActive)) ? "N" : (Convert.ToString(ValidList[i].isActive).ToLower() == "y" || Convert.ToString(ValidList[i].isActive).ToLower() == "yes") ? "Y" : "N",
LicenseNumber = Convert.ToString(ValidList[i].LicenseNumber).Trim(','),
DOB = Convert.ToString(ValidList[i].DOB).Trim(',')
};
Valid.Add(classObj);
}
ValidLists.Add(Valid);
});
validations.ChunkDriverdata = ValidLists;
return(validations);
}
public MessageResult AddNewDriver(DriversModel Driver)
{
int i = 0;
Guid ID = Guid.NewGuid(); //DriverID
MessageResult swResponse = new MessageResult();
try
{
using (SqlConnection conn = new SqlConnection(DBConn))
{
string sql = "INSERT INTO [dbo].[Drivers] ([ID],[FirstName] ,[MiddleName] ,[LastName] ,[PhoneNumber] ,[Email] ,[AddedBy])" +
"VALUES ( @ID,@FirstName,@MiddleName,@LastName,@PhoneNumber,@Email,@AddedBy)";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
cmd.Parameters.AddWithValue("@ID", ID.ToString().ToUpper());
cmd.Parameters.AddWithValue("@FirstName", Driver.FirstName);
cmd.Parameters.AddWithValue("@MiddleName", Driver.MiddleName);
cmd.Parameters.AddWithValue("@LastName", Driver.LastName);
cmd.Parameters.AddWithValue("@PhoneNumber", Driver.PhoneNumber);
cmd.Parameters.AddWithValue("@Email", Driver.Email);
cmd.Parameters.AddWithValue("@AddedBy", Driver.AddedBy);
i = cmd.ExecuteNonQuery();
conn.Close();
}
}
}
catch (Exception ex)
{
i = 0;
}
if (i == 0)
{
swResponse.Status = "warning";
swResponse.Message = "Failed to Insert. Try Again";
}
else
{
swResponse.Status = "success";
swResponse.Message = "User Added Successfully";
}
return(swResponse);
}
public JsonResult GetDriversModel()
{
var model = new DriversModel
{
Drivers = new List <Driver>
{
new Driver
{
FullName = "John Doe",
Cars = new List <Car>
{
new Car {
Code = "car0", Name = "Amazing car"
},
new Car {
Code = "car1", Name = "Cool car"
}
},
},
new Driver
{
FullName = "Johnny Dough",
Cars = new List <Car>
{
new Car {
Code = "car2", Name = "Another Amazing car"
}, new Car {
Code = "car3", Name = "Another Cool car"
}
}
},
}
};
return(Json(model, JsonRequestBehavior.AllowGet));
}
public JsonResult PostDriversModel(DriversModel model)
{
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
public int UpdateDriver(DriversModel Model)
{
return(_Ser.UpdateDriver(Model));
}
public int CreateDriver(DriversModel Model)
{
return(_Ser.CreateDriver(Model));
}
public long CabwithDriver(VehicleInfoModel Model, DriversModel Model1)
{
return(_Ser.CabwithDriver(Model, Model1));
}
