public ActionResult AddVendor(VendorModel model)
{
var countries = objVendor.GetVendors();
VendorDetails obj = new VendorDetails();
obj.Status = true;
try
{
obj.ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.InformationSave : "माहिती सेव केली आहे.";
model.IsActive = true;
if (model.RegistrationDate == null)
{
model.RegistrationDate = DateTime.Now.Date;
}
if (model.ExpiryDate == null)
{
model.ExpiryDate = DateTime.Now.Date.AddYears(1);
}
objVendor.Save(model);
int pageindex = 0;
var filter = countries.OrderBy(p => p.VendorId).Skip(pageindex * PageSize).Take(PageSize);
Session["users"] = countries;
Session["pageindex"] = 0;
obj.VendorList = filter;
}
catch (Exception)
{
obj.Status = false;
obj.ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.FailedToSave : "माहिती सेव करू शकत नाही.";
}
return(Json(obj, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> Edit(string id, [Bind("VendorID,VendorType,VendorName,VendorPhoto,VendorGps,ItemsAvailable,VendorContactNumber,VendorAlternateConatactNumber,VendorEmail,VendorAddress,Password,Hint,Remarks,Rating,Govt_ID_Proof")] VendorDetails vendorDetails)
{
if (id != vendorDetails.VendorID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(vendorDetails);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VendorDetailsExists(vendorDetails.VendorID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
return(View(vendorDetails));
}
public ActionResult PCDetails(VendorViewDetails vvd)
{
try
{
VendorDetails vd = new VendorDetails();
if (Session["Admin"] != null)
{
vd.VendorId = Convert.ToInt32(Session["Admin"]);
vd.NumberofProducts = vvd.NumberofProducts;
vd.AlreadySellingOnline = vvd.AlreadySellingOnline;
vd.NatureOfBusiness = vvd.NatureOfBusiness;
vd.OperatingFrom = vvd.OperatingFrom;
vd.HandleBy = vvd.HandleBy;
vd.Gender = vvd.Gender;
vd.Age = vvd.Age;
vd.MinPrice = vvd.MinPrice;
vd.MaxPrice = vvd.MaxPrice;
dbd.vendordetails.Add(vd);
dbd.SaveChanges();
return(RedirectToAction("BusinessDetails"));
}
ViewBag.errormessage = "Data not entered properly.";
return(View());
}
catch (Exception)
{
ViewBag.errormessage = "Data can't be inserted.";
return(View());
}
}
public ActionResult VendorFirst()
{
if (SettingsManager.Instance.Branding == "SINDHI")
{
IQueryable <UserRequests_Vendor> users = (IQueryable <UserRequests_Vendor>)Session["users"];
int pageindex = 0;
var filter = users.OrderBy(p => p.UserRequestID).Skip(pageindex * PageSize).Take(PageSize);
Session["users"] = users;
Session["pageindex"] = 0;
VendorDetails obj = new VendorDetails()
{
Status = true,
VendorListSPMO = filter
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
else
{
IQueryable <VendorModel> users = (IQueryable <VendorModel>)Session["users"];
int pageindex = 0;
var filter = users.OrderBy(p => p.VendorId).Skip(pageindex * PageSize).Take(PageSize);
Session["users"] = users;
Session["pageindex"] = 0;
VendorDetails obj = new VendorDetails()
{
Status = true,
VendorList = filter
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
public IActionResult Index()
{
var model = new VendorDetails();
model.Vendors = _vendorData.GetAll();
//var model = _context.Vendor.AsNoTracking();
return(View(model));
}
public ActionResult VendorLast()
{
if (SettingsManager.Instance.Branding == "SINDHI")
{
var users = objVendor.GetVendorsSPMO();
VendorDetails obj = new VendorDetails();
int pageindex = Convert.ToInt32(Session["pageindex"]);
pageindex++;
obj.Status = true;
if (users != null)
{
Session["pageindex"] = pageindex;
if ((users.Count() % PageSize) == 0)
{
obj.VendorListSPMO = users.OrderBy(p => p.UserRequestID).Skip(users.Count() - PageSize).Take(PageSize);
return(Json(obj, JsonRequestBehavior.AllowGet));
}
else
{
int rem = users.Count() % PageSize;
obj.VendorListSPMO = users.OrderBy(p => p.UserRequestID).Skip(users.Count() - rem).Take(PageSize);
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
else
{
return(VendorFirst());
}
}
else
{
var users = objVendor.GetVendors();
VendorDetails obj = new VendorDetails();
int pageindex = Convert.ToInt32(Session["pageindex"]);
pageindex++;
obj.Status = true;
if (users != null)
{
Session["pageindex"] = pageindex;
if ((users.Count() % PageSize) == 0)
{
obj.VendorList = users.OrderBy(p => p.VendorId).Skip(users.Count() - PageSize).Take(PageSize);
return(Json(obj, JsonRequestBehavior.AllowGet));
}
else
{
int rem = users.Count() % PageSize;
obj.VendorList = users.OrderBy(p => p.VendorId).Skip(users.Count() - rem).Take(PageSize);
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
else
{
return(VendorFirst());
}
}
}
public ActionResult SearchVendor(string prefix)
{
if (SettingsManager.Instance.Branding == "SINDHI")
{
var countries = objVendor.GetVendorsSPMO().Where(p => p.VendorName.Contains(prefix.ToUpper()) || p.Address.Contains(prefix) || p.ContactNo.Contains(prefix));
int pageindex = 0;
var filter = countries.OrderBy(p => p.UserRequestID).Skip(pageindex * PageSize).Take(PageSize);
Session["users"] = countries;
Session["pageindex"] = 0;
if (filter.Count() > 0)
{
VendorDetails obj = new VendorDetails()
{
Status = true,
VendorListSPMO = filter
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
else
{
VendorDetails obj = new VendorDetails()
{
Status = false,
ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.NoMoreInformationAvail : "आणखी माहिती उपलब्ध नाही."
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
else
{
var countries = objVendor.GetVendors().Where(p => p.VendorName.ToUpper() == prefix.ToUpper());
int pageindex = 0;
var filter = countries.OrderBy(p => p.VendorId).Skip(pageindex * PageSize).Take(PageSize);
Session["users"] = countries;
Session["pageindex"] = 0;
if (filter.Count() > 0)
{
VendorDetails obj = new VendorDetails()
{
Status = true,
VendorList = filter
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
else
{
VendorDetails obj = new VendorDetails()
{
Status = false,
ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.NoMoreInformationAvail : "आणखी माहिती उपलब्ध नाही."
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
}
// GET: Vendors/Details/5
public async Task <ActionResult> Details(int?id)
{
if (!User.Identity.IsAuthenticated)
{
return(RedirectToAction("Login", "Account"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//Check if user belongs to this vendor. If not, deny access
string userId = User.Identity.GetUserId();
var user = await db.Users.FirstOrDefaultAsync(x => x.Id == userId);
int userVendorID = user.VendorID;
if (userVendorID != id && !(User.IsInRole("Administrator") || User.IsInRole("Manager")))
{
return(RedirectToAction("Warning", "Home", new { message = "ACCESS DENIED - You can't view other Vendor Details" }));
}
Vendor vendor = await db.Vendors.FindAsync(id);
if (vendor == null)
{
return(HttpNotFound());
}
// Find all users with this vendor
var users = db.Users.Where(x => x.VendorID == id);
// Create view model to return
VendorDetails vd = new VendorDetails();
vd.Vendor = vendor;
vd.Users = new List <UserBasicDetails>();
foreach (var item in users)
{
UserBasicDetails temp = new UserBasicDetails
{
FirstName = item.FirstName,
LastName = item.LastName,
Email = item.Email,
Phone = item.PersonalPhone
};
vd.Users.Add(temp);
}
return(View(vd));
}
public async Task <IActionResult> Create([Bind("VendorID,VendorType,VendorName,VendorPhoto,VendorGps,ItemsAvailable,VendorContactNumber,VendorAlternateConatactNumber,VendorEmail,VendorAddress,Password,Hint,Remarks,Rating,Govt_ID_Proof")] VendorDetails vendorDetails)
{
if (ModelState.IsValid)
{
_context.Add(vendorDetails);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(vendorDetails));
}
public IActionResult EditVendor([FromBody] VendorForm form)
{
var error = new Error();
var vendor = _vendorManager.UpdateVendor(form.MapToCore(), ref error);
if (error.ErrorCode != ErrorCode.OKAY)
{
return(BadRequest(error.Message));
}
return(Ok(VendorDetails.MapFromObject(vendor, _responseGenerator)));
}
public IActionResult GetVendorDetails(int vendorId)
{
var vendor = _vendorManager.GetVendorDetails(vendorId);
if (vendor == null)
{
return(NoContent());
}
var response = VendorDetails.MapFromObject(vendor, _responseGenerator);
return(Ok(response));
}
public ActionResult Update(VendorModel model)
{
var countries = objVendor.GetVendors();
//var test = countries.Where(p => p.Vendor.ToUpper() == model.Vendor.ToUpper()).FirstOrDefault();
VendorDetails obj = new VendorDetails();
obj.Status = true;
obj.ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.UpdateSuccess : "माहिती मध्ये बदल केला आहे.";
objVendor.Update(model);
int pageindex = 0;
var filter = countries.OrderBy(p => p.VendorId).Skip(pageindex * PageSize).Take(PageSize);
Session["users"] = countries;
Session["pageindex"] = 0;
obj.VendorList = filter;
return(Json(obj, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// The Get Vendors List method
/// </summary>
/// <returns>return list</returns>
public IList <VendorDetails> GetSavedVendorDetailes()
{
SqlDatabase sqlConn;
DbCommand databaseCommand;
List <VendorDetails> olist = null;
try
{
sqlConn = new SqlDatabase(ConnectionInfo.GetConnectionString);
databaseCommand = sqlConn.GetStoredProcCommand("TS_GetSavedVendorData");
databaseCommand.CommandType = CommandType.StoredProcedure;
//Parameters
using (IDataReader databaseReader = sqlConn.ExecuteReader(databaseCommand))
{
olist = new List <VendorDetails>();
while (databaseReader.Read())
{
VendorDetails oSavedData = CreateObject.GetObject <VendorDetails>();
oSavedData.Vendorname = Convert.ToString(databaseReader["Vendorname"]).ToUpper();
oSavedData.VendorContactNO = Convert.ToString(databaseReader["VendorContactNO"]);
oSavedData.VendorID = Convert.ToInt32(databaseReader["VendorID"]);
oSavedData.VendorEmail = Convert.ToString(databaseReader["VendorEmail"]);
olist.Add(oSavedData);
}
}
return(olist);
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlConn = null;
databaseCommand = null;
}
}
public ActionResult VendorNext()
{
if (SettingsManager.Instance.Branding == "SINDHI")
{
IQueryable <UserRequests_Vendor> users = (IQueryable <UserRequests_Vendor>)Session["users"];
if (users != null)
{
int pageindex = Convert.ToInt32(Session["pageindex"]);
pageindex++;
var filter = users.OrderBy(p => p.VendorId).Skip(pageindex * PageSize).Take(PageSize);
if (filter.Count() > 0)
{
Session["pageindex"] = pageindex;
VendorDetails obj = new VendorDetails()
{
Status = true,
ErrorMessage = "",
VendorListSPMO = filter
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
else
{
VendorDetails obj = new VendorDetails()
{
Status = false,
ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.NoMoreInformationAvail : "आणखी माहिती उपलब्ध नाही."
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
else
{
return(VendorFirst());
}
}
else
{
IQueryable <VendorModel> users = (IQueryable <VendorModel>)Session["users"];
if (users != null)
{
int pageindex = Convert.ToInt32(Session["pageindex"]);
pageindex++;
var filter = users.OrderBy(p => p.VendorId).Skip(pageindex * PageSize).Take(PageSize);
if (filter.Count() > 0)
{
Session["pageindex"] = pageindex;
VendorDetails obj = new VendorDetails()
{
Status = true,
ErrorMessage = "",
VendorList = filter
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
else
{
VendorDetails obj = new VendorDetails()
{
Status = false,
ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.NoMoreInformationAvail : "आणखी माहिती उपलब्ध नाही."
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
else
{
return(VendorFirst());
}
}
}
public void InsertEndOfDayData(IEnumerable <IStockDataModel> stockDataCollection, VendorDetails vendorDetails)
{
IStockDataModel stockData = stockDataCollection.First();
_logger.Information($"PersistenceManager: Inserting stock data for {stockData.Symbol}");
int?securityId = GetSecurityIdBySymbol(stockData.Symbol);
if (!securityId.HasValue)
{
throw new ArgumentException($"Attempting to insert stock data for {stockData.Symbol} which doesn't exist.");
}
var commandStringBuilder = new StringBuilder("INSERT INTO EndOfDayData(SecurityId, VendorId, Open, High, Low, Close, AdjustedClose, Volume, DayChange, DayPercentageChange, StandardChange, StandardPercentageChange, DateStamp) Values");
foreach (IStockDataModel data in stockDataCollection)
{
string standardChange = data.StandardChange.HasValue ? data.StandardChange.ToString() : "NULL";
string standardChangePercentage = data.StandardPercentageChange.HasValue ? data.StandardPercentageChange.ToString() : "NULL";
commandStringBuilder.Append($"({securityId.Value}, {(int)vendorDetails}, {data.Open}, {data.High}, {data.Low}, {data.Close}, {data.AdjustedClose}, {data.Volume}, {data.DayChange}, {data.DayPercentageChange}, {standardChange}, {standardChangePercentage}, '{data.TimeStamp.Date.ToString("yyyy-MM-dd")}'),\n");
}
int rowCount = stockDataCollection.Count();
_logger.Information($"PersistenceManager: Persisting {rowCount} rows for {stockData.Symbol}");
commandStringBuilder.Length -= 2;
ExecuteNoReadQuery(commandStringBuilder.ToString(), rowCount, new Dictionary <string, object>());
}
//Call from ajax
public JsonResult GetDetails(int?id, DateTime?fromDate, DateTime?toDate)
{
var data = new VendorDetails(_db, id.GetValueOrDefault(), fromDate, toDate);
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult VendorPrev()
{
if (SettingsManager.Instance.Branding == "SINDHI")
{
IQueryable <UserRequests_Vendor> users = (IQueryable <UserRequests_Vendor>)Session["users"];
if (users != null)
{
int pageindex = Convert.ToInt32(Session["pageindex"]);
if (pageindex > 0)
{
pageindex--;
var filter = users.OrderBy(p => p.UserRequestID).Skip(pageindex * PageSize).Take(PageSize);
Session["pageindex"] = pageindex;
VendorDetails obj = new VendorDetails()
{
Status = true,
ErrorMessage = "",
VendorListSPMO = filter,
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
else
{
VendorDetails obj = new VendorDetails()
{
Status = false,
ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.FirstPage : "तुम्ही पहिल्याच पानावर आहात",
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
else
{
return(VendorFirst());
}
}
else
{
IQueryable <VendorModel> users = (IQueryable <VendorModel>)Session["users"];
if (users != null)
{
int pageindex = Convert.ToInt32(Session["pageindex"]);
if (pageindex > 0)
{
pageindex--;
var filter = users.OrderBy(p => p.VendorId).Skip(pageindex * PageSize).Take(PageSize);
Session["pageindex"] = pageindex;
VendorDetails obj = new VendorDetails()
{
Status = true,
ErrorMessage = "",
VendorList = filter,
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
else
{
VendorDetails obj = new VendorDetails()
{
Status = false,
ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.FirstPage : "तुम्ही पहिल्याच पानावर आहात",
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
else
{
return(VendorFirst());
}
}
}
