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