public List <VendorSearchModel> GetVendorDataList(VendorSearchModel model)
{
ShomaRMEntities db = new ShomaRMEntities();
List <VendorSearchModel> lstVendor = new List <VendorSearchModel>();
try
{
DataTable dtTable = new DataTable();
using (var cmd = db.Database.Connection.CreateCommand())
{
db.Database.Connection.Open();
cmd.CommandText = "usp_GetVendorPaginationAndSearchData";
cmd.CommandType = CommandType.StoredProcedure;
DbParameter paramDF = cmd.CreateParameter();
paramDF.ParameterName = "FromDate";
paramDF.Value = model.FromDate;
cmd.Parameters.Add(paramDF);
DbParameter paramDT = cmd.CreateParameter();
paramDT.ParameterName = "ToDate";
paramDT.Value = model.ToDate;
cmd.Parameters.Add(paramDT);
DbParameter paramPN = cmd.CreateParameter();
paramPN.ParameterName = "PageNumber";
paramPN.Value = model.PageNumber;
cmd.Parameters.Add(paramPN);
DbParameter paramNOR = cmd.CreateParameter();
paramNOR.ParameterName = "NumberOfRows";
paramNOR.Value = model.NumberOfRows;
cmd.Parameters.Add(paramNOR);
DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter();
da.SelectCommand = cmd;
da.Fill(dtTable);
db.Database.Connection.Close();
}
foreach (DataRow dr in dtTable.Rows)
{
VendorSearchModel searchmodel = new VendorSearchModel();
searchmodel.Vendor_ID = Convert.ToInt64(dr["Vendor_ID"].ToString());
searchmodel.Vendor_Name = dr["Vendor_Name"].ToString();
searchmodel.Mobile_Number = dr["Mobile_Number"].ToString();
searchmodel.Email_Id = dr["Email_Id"].ToString();
searchmodel.Address = dr["Address"].ToString();
searchmodel.State = dr["State"].ToString();
searchmodel.City = dr["City"].ToString();
lstVendor.Add(searchmodel);
}
db.Dispose();
return(lstVendor.ToList());
}
catch (Exception ex)
{
db.Database.Connection.Close();
throw ex;
}
}
/// <summary>
/// Prepare paged vendor list model
/// </summary>
/// <param name="searchModel">Vendor search model</param>
/// <returns>Vendor list model</returns>
public virtual VendorListModel PrepareVendorListModel(VendorSearchModel searchModel)
{
if (searchModel == null)
{
throw new ArgumentNullException(nameof(searchModel));
}
//get vendors
var vendors = _vendorService.GetAllVendors(showHidden: true,
name: searchModel.SearchName,
pageIndex: searchModel.Page - 1, pageSize: searchModel.PageSize);
//prepare list model
var model = new VendorListModel().PrepareToGrid(searchModel, vendors, () =>
{
//fill in model values from the entity
return(vendors.Select(vendor =>
{
var vendorModel = vendor.ToModel <VendorModel>();
vendorModel.SeName = _urlRecordService.GetSeName(vendor, 0, true, false);
return vendorModel;
}));
});
return(model);
}
public List <VendorSearchModel> GetAll(VendorSearchModel model)
{
return(context.vw_GetVendor
.Where(x => x.DisciplineId == (model.DisciplineId == null ? x.DisciplineId : model.DisciplineId) &&
x.AdminApproval == (model.AdminApproval == null ? x.AdminApproval : model.AdminApproval))
.Select(x => new VendorSearchModel()
{
VendorId = x.VendorId,
VendorName = x.VendorName,
EmailId = x.EmailId,
Password = x.Password,
DisciplineId = x.DisciplineId,
DisciplineName = x.DisciplineName,
OtherDisciplineName = x.OtherDisciplineName,
MobileNumber = x.MobileNumber,
CompanyBrief = x.CompanyBrief,
ActualTradeAndBusinessFile = x.ActualTradeAndBusinessFile,
TradeAndBusinessFile = x.TradeAndBusinessFile,
ImageFile = x.ImageFile,
ActualImageFile = x.ActualImageFile,
Remark = x.Remark,
AdminApproval = x.AdminApproval,
AdminApprovalText = x.AdminApprovalText,
Status = x.Status,
CreatedOn = x.CreatedOn,
}).ToList());
}
private ActionResult BindList(VendorSearchModel model)
{
VendorHelper _Helper = new VendorHelper();
var List = _Helper.GetAll(model);
ActiveList = List.Where(x => x.Status == 1).OrderBy(x => x.Status).ThenBy(a => a.AdminApproval).ThenByDescending(o => o.CreatedOn).ToList();
InActiveList = List.Where(x => x.Status == 0).OrderBy(x => x.Status).ThenBy(a => a.AdminApproval).ThenByDescending(o => o.CreatedOn).ToList();
return(View(Tuple.Create(ActiveList, InActiveList, model)));
}
public IActionResult VendorsList([FromQuery] VendorSearchModel searchModel)
{
var vendors = _vendorService.GetVendors(out var totalMatches, searchModel.SearchPhrase, searchModel.UserId, searchModel.VendorStatus, searchModel.Current, searchModel.RowCount);
var vendorModels = vendors.Select(x => _modelMapper.Map <VendorModel>(x)).ToList();
return(R.Success.With("vendors", vendorModels)
.WithGridResponse(totalMatches, searchModel.Current, searchModel.RowCount)
.Result);
}
public virtual IActionResult List(VendorSearchModel searchModel)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageVendors))
{
return(AccessDeniedDataTablesJson());
}
//prepare model
var model = _vendorModelFactory.PrepareVendorListModel(searchModel);
return(Json(model));
}
/// <summary>
/// Prepare vendor search model
/// </summary>
/// <param name="searchModel">Vendor search model</param>
/// <returns>Vendor search model</returns>
public virtual VendorSearchModel PrepareVendorSearchModel(VendorSearchModel searchModel)
{
if (searchModel == null)
{
throw new ArgumentNullException(nameof(searchModel));
}
//prepare page parameters
searchModel.SetGridPageSize();
return(searchModel);
}
/// <summary>
/// Prepare vendor search model
/// </summary>
/// <param name="searchModel">Vendor search model</param>
/// <returns>
/// A task that represents the asynchronous operation
/// The task result contains the vendor search model
/// </returns>
public virtual Task <VendorSearchModel> PrepareVendorSearchModelAsync(VendorSearchModel searchModel)
{
if (searchModel == null)
{
throw new ArgumentNullException(nameof(searchModel));
}
//prepare page parameters
searchModel.SetGridPageSize();
return(Task.FromResult(searchModel));
}
/// <returns>A task that represents the asynchronous operation</returns>
public virtual async Task <IActionResult> List(VendorSearchModel searchModel)
{
if (!await _permissionService.AuthorizeAsync(StandardPermissionProvider.ManageVendors))
{
return(await AccessDeniedDataTablesJson());
}
//prepare model
var model = await _vendorModelFactory.PrepareVendorListModelAsync(searchModel);
return(Json(model));
}
public int BuildPaganationVendorList(VendorSearchModel model)
{
int NOP = 0;
ShomaRMEntities db = new ShomaRMEntities();
try
{
DataTable dtTable = new DataTable();
using (var cmd = db.Database.Connection.CreateCommand())
{
db.Database.Connection.Open();
cmd.CommandText = "usp_GetVendorPaginationAndSearchData";
cmd.CommandType = CommandType.StoredProcedure;
DbParameter paramDF = cmd.CreateParameter();
paramDF.ParameterName = "FromDate";
paramDF.Value = model.FromDate;
cmd.Parameters.Add(paramDF);
DbParameter paramDT = cmd.CreateParameter();
paramDT.ParameterName = "ToDate";
paramDT.Value = model.ToDate;
cmd.Parameters.Add(paramDT);
DbParameter paramPN = cmd.CreateParameter();
paramPN.ParameterName = "PageNumber";
paramPN.Value = model.PageNumber;
cmd.Parameters.Add(paramPN);
DbParameter paramNOR = cmd.CreateParameter();
paramNOR.ParameterName = "NumberOfRows";
paramNOR.Value = model.NumberOfRows;
cmd.Parameters.Add(paramNOR);
DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter();
da.SelectCommand = cmd;
da.Fill(dtTable);
db.Database.Connection.Close();
}
if (dtTable.Rows.Count > 0)
{
NOP = int.Parse(dtTable.Rows[0]["NumberOfPages"].ToString());
}
db.Dispose();
return(NOP);
}
catch (Exception ex)
{
db.Database.Connection.Close();
throw ex;
}
}
/// <summary>
/// Build dynamic where clause with criteria value.
/// </summary>
/// <param name="model">The criteria value.</param>
/// <returns></returns>
private Expression <Func <Data.Pocos.Vendor, bool> > BuildDynamicWhereClause(VendorSearchModel model)
{
// simple method to dynamically plugin a where clause
var predicate = PredicateBuilder.True <Data.Pocos.Vendor>(); // true -where(true) return all
if (model != null)
{
if (!string.IsNullOrEmpty(model.VendorNo))
{
predicate = predicate.And(s => s.VendorNo.Contains(model.VendorNo));
}
if (!string.IsNullOrEmpty(model.VendorName))
{
predicate = predicate.And(s => s.VendorName.Contains(model.VendorName));
}
}
return(predicate);
}
/// <summary>
/// Prepare paged vendor list model
/// </summary>
/// <param name="searchModel">Vendor search model</param>
/// <returns>Vendor list model</returns>
public virtual VendorListModel PrepareVendorListModel(VendorSearchModel searchModel)
{
if (searchModel == null)
{
throw new ArgumentNullException(nameof(searchModel));
}
//get vendors
var vendors = _vendorService.GetAllVendors(showHidden: true,
name: searchModel.SearchName,
pageIndex: searchModel.Page - 1, pageSize: searchModel.PageSize);
//prepare list model
var model = new VendorListModel
{
//fill in model values from the entity
Data = vendors.Select(vendor => vendor.ToModel <VendorModel>()),
Total = vendors.TotalCount
};
return(model);
}
public ActionResult Index(VendorSearchModel model)
{
return(BindList(model));
}
int MaxFileLength = 50; // in MB
// GET: Administrator/Vendor
public ActionResult Index()
{
VendorSearchModel model = new VendorSearchModel();
return(BindList(model));
}
public ActionResult Directory(VendorSearchModel _model)
{
ViewBag.VendorList = VendorHelper.Instance.SearchVendors(_model.keyword, _model.disciplineid, 1);
return(View(_model));
}
