/// <summary>
/// Get Transporter Info using UserId
/// </summary>
/// <param name="userid">User Id</param>
/// <returns>Transporter</returns>
public static Transporter GetTransporterInfo(int userid)
{
DataTable dt = new DataTable();
Transporter transporter = new Transporter();
TMSDataLibrary.Transporter _transporterdata = new TMSDataLibrary.Transporter();
dt = _transporterdata.GetTransporterInfo(userid);
if (dt.Rows.Count > 0)
{
transporter.TransporterId = (int)dt.Rows[0][CONSTS.TransporterColumnIndex.TransporterId];
transporter.UserId = (int)dt.Rows[0][CONSTS.TransporterColumnIndex.UserId];
transporter.TransportName = dt.Rows[0][CONSTS.TransporterColumnIndex.Transportname].ToString();
transporter.FirstName = dt.Rows[0][CONSTS.TransporterColumnIndex.FirstName].ToString();
transporter.LastName = dt.Rows[0][CONSTS.TransporterColumnIndex.LastName].ToString();
transporter.Mobile = dt.Rows[0][CONSTS.TransporterColumnIndex.Mobile].ToString();
transporter.Email = dt.Rows[0][CONSTS.TransporterColumnIndex.Email].ToString();
transporter.AddressLine = dt.Rows[0][CONSTS.TransporterColumnIndex.AddressLine].ToString();
transporter.Pincode = dt.Rows[0][CONSTS.TransporterColumnIndex.Pincode].ToString();
transporter.CityId = Convert.ToInt32(dt.Rows[0][CONSTS.TransporterColumnIndex.CityId]);
transporter.CityName = dt.Rows[0][CONSTS.TransporterColumnIndex.CityName].ToString();
if (dt.Rows[0][CONSTS.TransporterColumnIndex.ProfilePhoto].ToString() != "")
{
transporter.ProfilePhoto = dt.Rows[0][CONSTS.TransporterColumnIndex.ProfilePhoto].ToString();
}
if (dt.Rows[0][CONSTS.TransporterColumnIndex.AltContactNo].ToString() != "")
{
transporter.AltContactName = dt.Rows[0][CONSTS.TransporterColumnIndex.AltContactNo].ToString();
}
if (dt.Rows[0][CONSTS.TransporterColumnIndex.AltMobileNo].ToString() != "")
{
transporter.AltMobileNo = dt.Rows[0][CONSTS.TransporterColumnIndex.AltMobileNo].ToString();
}
if (dt.Rows[0][CONSTS.TransporterColumnIndex.StdCode].ToString() != "")
{
transporter.StdCode = Convert.ToDecimal(dt.Rows[0][CONSTS.TransporterColumnIndex.StdCode]);
}
if (dt.Rows[0][CONSTS.TransporterColumnIndex.LandlineNo].ToString() != "")
{
transporter.LandlineNo = Convert.ToDecimal(dt.Rows[0][CONSTS.TransporterColumnIndex.LandlineNo]);
}
if (dt.Rows[0][CONSTS.TransporterColumnIndex.Fax].ToString() != "")
{
transporter.Fax = Convert.ToDecimal(dt.Rows[0][CONSTS.TransporterColumnIndex.Fax]);
}
if (dt.Rows[0][CONSTS.TransporterColumnIndex.ServiceTaxNo].ToString() != "")
{
transporter.ServiceTaxNo = dt.Rows[0][CONSTS.TransporterColumnIndex.ServiceTaxNo].ToString();
}
if (dt.Rows[0][CONSTS.TransporterColumnIndex.PanNumber].ToString() != "")
{
transporter.PanNumber = dt.Rows[0][CONSTS.TransporterColumnIndex.PanNumber].ToString();
}
if (dt.Rows[0][CONSTS.TransporterColumnIndex.Franchise].ToString() != "")
{
var teamp = dt.Rows[0][CONSTS.TransporterColumnIndex.Franchise];
transporter.Franchise = Convert.ToInt32(dt.Rows[0][CONSTS.TransporterColumnIndex.Franchise]);
}
if (dt.Rows[0][CONSTS.TransporterColumnIndex.EstablishYear].ToString() != "")
{
transporter.EstablishYear = dt.Rows[0][CONSTS.TransporterColumnIndex.EstablishYear].ToString();
}
if (dt.Rows[0][CONSTS.TransporterColumnIndex.Website].ToString() != "")
{
transporter.Website = dt.Rows[0][CONSTS.TransporterColumnIndex.Website].ToString();
}
if (dt.Rows[0][CONSTS.TransporterColumnIndex.UpdatedAt].ToString() != "")
{
transporter.UpdatedAt = (DateTime)dt.Rows[0][CONSTS.TransporterColumnIndex.UpdatedAt];
}
transporter.TransporterNo = (String)dt.Rows[0][CONSTS.TransporterColumnIndex.TransporterNo];
}
return transporter;
}
/// <summary>
/// Get All Transporter
/// </summary>
/// <returns>datatable of Transporter</returns>
public static DataTable GetTransporterInfo()
{
TMSDataLibrary.Transporter transporter = new TMSDataLibrary.Transporter();
return transporter.GetTransporterInfo();
}
