public List<VendorDetailsModel> DeleteVendor(long Id, long bulkBuyID) { List<VendorDetailsModel> lstvendors = new List<VendorDetailsModel>(); using (ShopDevEntities db = new ShopDevEntities()) { try { VendorDetail vendor = GetVendor(db, Id); db.VendorDetails.Remove(vendor); db.SaveChanges(); var lstproducts = db.VendorDetails.Where(m => m.BulkByID == bulkBuyID).ToList(); foreach (var cusprod in lstproducts) { VendorDetailsModel objvendor = new VendorDetailsModel(); cusprod.CopyProperties(objvendor); lstvendors.Add(objvendor); } } catch (Exception) { } return lstvendors; } }
public AddNewVendorFrm(UniEnums.VendorType vendorType) { InitializeComponent(); _vendor = new VendorDetail() { VendorType = vendorType.ToString(), ProcessedDate = DateTime.Now.Date }; _isNewRecord = true; _vendorType = vendorType; }
public VendorDetail ShowVendor(int vendorId) { var form = new VendorDetail(); form.ShowObject(vendorId); return(form); }
public IHttpActionResult VendorRegistrationAddUpdate([FromBody] VendorDetail vendorDetails) { if (vendorDetails.Phone <= 0 || vendorDetails.Phone.ToString().Length < 10) { return(BadRequest(InvalidPhoneNumberMessage)); } if (string.IsNullOrEmpty(vendorDetails.VendorName)) { return(BadRequest("Invalid vendor name")); } var existingVendorDetail = communitieswinEntities.vendor_details.FirstOrDefault(x => x.phone == vendorDetails.Phone); if (existingVendorDetail == null) { existingVendorDetail = new vendor_details { phone = vendorDetails.Phone, vendor_name = vendorDetails.VendorName, country = vendorDetails.Country, city = vendorDetails.City, state = vendorDetails.State, pin = vendorDetails.Pin, latitude = vendorDetails.Latitude, longitude = vendorDetails.Longitude }; communitieswinEntities.vendor_details.Add(existingVendorDetail); } else { existingVendorDetail.vendor_name = vendorDetails.VendorName; existingVendorDetail.latitude = vendorDetails.Latitude; existingVendorDetail.longitude = vendorDetails.Longitude; existingVendorDetail.city = vendorDetails.City; existingVendorDetail.state = vendorDetails.State; existingVendorDetail.pin = vendorDetails.Pin; existingVendorDetail.country = vendorDetails.Country; } communitieswinEntities.SaveChanges(); if (!string.IsNullOrEmpty(vendorDetails.Categories)) { var categories = vendorDetails.Categories.Split(','); foreach (var category in categories) { long categoryId = SaveCategory(category.Trim()); var vendorCategory = communitieswinEntities.vendor_category.FirstOrDefault(x => x.vendor_id == existingVendorDetail.vendor_id && x.category_id == categoryId); if (vendorCategory == null) { communitieswinEntities.vendor_category.Add(new vendor_category() { vendor_id = existingVendorDetail.vendor_id, category_id = categoryId, is_active = true }); } } } return(Ok()); }
/// <summary> /// Saving vendor from SAP to Database /// Date: 20 June 2019 /// Developer: Shreyans Khandelwal (0538) /// </summary> public void SaveVendor() { try { VendorDetail vendorDetail = new VendorDetail(); //vendorDetail = objSapVendor.GetVendor(); vendorDetail.PanNumber = "0192873661"; int venId = 0; bool addAssoCompany = false; //allowing to add vendor only if PAN number is available if (!string.IsNullOrEmpty(vendorDetail.PanNumber)) { //checking if vendor already exist on basis of PAN number var vendorId = (from data in finocartEntities.Company where data.Pan_number == vendorDetail.PanNumber select data.CompanyID).FirstOrDefault(); //if vendor exist linking it to new company if (vendorId > 0) { var vendorAssociate = (from data in finocartEntities.VendorAssociatedCompany where data.VendorId == vendorId && data.CompanyId == 5678 select data).FirstOrDefault(); if (vendorAssociate == null) { venId = vendorId; addAssoCompany = true; } } //If vendor does not exist adding it to DB else { vendorDetail.InstretedAs = (from data in finocartEntities.LookupDetails where data.LookupValue == "Vendor" && data.LookupFor == "AccessView" select data.ID).FirstOrDefault(); Company company = MapCompany(vendorDetail); finocartEntities.Company.Add(company); finocartEntities.SaveChanges(); addAssoCompany = true; venId = company.CompanyID; } //Linking vendor to the company if (addAssoCompany) { if (!finocartEntities.VendorAssociatedCompany.Where(data => data.VendorId == venId && data.CompanyId == 57).Any()) { VendorAssociatedCompany vendorAssociatedCompany = new VendorAssociatedCompany(); vendorAssociatedCompany.VendorId = venId; vendorAssociatedCompany.CompanyId = 57; finocartEntities.VendorAssociatedCompany.Add(vendorAssociatedCompany); finocartEntities.SaveChanges(); } } } } catch (Exception ex) { logger.WriteLog(ex); throw ex; } }
public AddNewVendorFrm(long srNo, UniEnums.VendorType vendorType) { InitializeComponent(); _vendorType = vendorType; _vendor = _uniDb.VendorDetails.Single(x => x.SrNo == srNo && x.VendorType == vendorType.ToString()); _isNewRecord = false; }
//[HttpPost] //public ActionResult Index(VendorDetail model) //{ // var em = model.Email; // var name = model.Name; //} public ActionResult SendMailBtn(VendorDetail v) { string email = Request.Form["emailId"]; string message = Request.Form["message"]; Execute(email, message).Wait(1000); //How to add notify.js or sweetAlert.js here or any other notification return(Redirect("~/Vendor/Index")); }
// vendor public List<VendorDetailsModel> AddVendor(VendorDetailsModel vendorModel) { List<VendorDetailsModel> lstvendors = new List<VendorDetailsModel>(); using (ShopDevEntities db = new ShopDevEntities()) { try { vendorModel.BulkByID = vendorModel.BulkByID == null ? 0 : vendorModel.BulkByID; VendorDetail vendordetails = null; if (vendorModel.VendorCode == null) { Vendor vendor = new Vendor { VendorName = vendorModel.VendorName, Address = vendorModel.Address, MobileNo= vendorModel.MobileNo, TotalBulks=1 }; db.Vendors.Add(vendor); db.SaveChanges(); vendorModel.VendorCode = vendor.VendorCode; } if (vendorModel.BuyVendorID > 0) { vendordetails = db.VendorDetails.Where(m => m.BuyVendorID == vendorModel.BuyVendorID).FirstOrDefault(); } else { vendordetails = new VendorDetail(); } vendorModel.CopyProperties(vendordetails); if (vendorModel.BuyVendorID == 0) { db.VendorDetails.Add(vendordetails); } db.SaveChanges(); var lstAllvendors = db.VendorDetails.Where(m => m.BulkByID == vendorModel.BulkByID).ToList(); foreach (var cusprod in lstAllvendors) { VendorDetailsModel objcsproduct = new VendorDetailsModel(); cusprod.CopyProperties(objcsproduct); lstvendors.Add(objcsproduct); } return lstvendors; } catch (Exception) { return lstvendors; } } }
public VendorDetail GetVendorDetailsById(int id) { try { VendorDetail result = new VendorDetail(); var vendor = _context.SubContractor.Where(x => x.Id == id && x.IsDelete == false) .Include(s => s.SubContractorServiceType).FirstOrDefault(); result = _mapper.Map <VendorDetail> (vendor); return(result); } catch (Exception ex) { throw ex; } }
public VendorDetail GetVendor(ShopDevEntities db, long Id) { VendorDetail objvendor = null; try { objvendor = db.VendorDetails.Where(m => m.BuyVendorID == Id).FirstOrDefault(); } catch (Exception) { } return objvendor; }
/// <summary> /// Getting vendor details from SAP /// Date: 20 June 2019 /// Developer: Shreyans Khandelwal (0538) /// </summary> /// <param name="rfcDest"></param> /// <returns></returns> public VendorDetail GetVendorDetail(RfcDestination rfcDest) { try { VendorDetail vendorDetModel = new VendorDetail(); RfcDestination SAPRfcDestination = RfcDestinationManager.GetDestination("accelyides"); RfcRepository rfcrep = SAPRfcDestination.Repository; IRfcFunction BapiGetCompanyDetail = null; BapiGetCompanyDetail = rfcrep.CreateFunction("BAPI_VENDOR_GETDETAIL"); BapiGetCompanyDetail.SetValue("VENDORNO", "VBX"); BapiGetCompanyDetail.SetValue("COMPANYCODE", "0001"); BapiGetCompanyDetail.Invoke(rfcDest); IRfcStructure IRS_OS_GeneralDet = BapiGetCompanyDetail.GetStructure("GENERALDETAIL"); vendorDetModel.CompanyName = IRS_OS_GeneralDet.GetValue("VENDOR").ToString(); vendorDetModel.ContactName = IRS_OS_GeneralDet.GetValue("NAME").ToString(); vendorDetModel.ContactMobile = IRS_OS_GeneralDet.GetValue("TELEPHONE").ToString(); vendorDetModel.Address = IRS_OS_GeneralDet.GetValue("FORMOFADDR").ToString(); //vendorDetModel.NAME_2 = IRS_OS_GeneralDet.GetValue("NAME_2").ToString(); //vendorDetModel.NAME_3 = IRS_OS_GeneralDet.GetValue("NAME_3").ToString(); //vendorDetModel.NAME_4 = IRS_OS_GeneralDet.GetValue("NAME_4").ToString(); //vendorDetModel.CITY = IRS_OS_GeneralDet.GetValue("CITY").ToString(); //vendorDetModel.DISTRICT = IRS_OS_GeneralDet.GetValue("DISTRICT").ToString(); //vendorDetModel.PO_BOX = IRS_OS_GeneralDet.GetValue("PO_BOX").ToString(); //vendorDetModel.POBX_PCD = IRS_OS_GeneralDet.GetValue("POBX_PCD").ToString(); //vendorDetModel.POSTL_CODE = IRS_OS_GeneralDet.GetValue("POSTL_CODE").ToString(); //vendorDetModel.REGION = IRS_OS_GeneralDet.GetValue("REGION").ToString(); ////vendorDetModel.Address = IRS_OS_GeneralDet.GetValue("STREET").ToString(); //vendorDetModel.COUNTRY = IRS_OS_GeneralDet.GetValue("STREET").ToString(); //vendorDetModel.COUNTRYISO = IRS_OS_GeneralDet.GetValue("COUNTRYISO").ToString(); //vendorDetModel.POBX_CTY = IRS_OS_GeneralDet.GetValue("POBX_CTY").ToString(); //vendorDetModel.LANGU = IRS_OS_GeneralDet.GetValue("LANGU").ToString(); //vendorDetModel.LANGU_ISO = IRS_OS_GeneralDet.GetValue("LANGU_ISO").ToString(); //vendorDetModel.TELEPHONE2 = IRS_OS_GeneralDet.GetValue("TELEPHONE2").ToString(); RfcSessionManager.EndContext(rfcDest); return(vendorDetModel); } catch (Exception ex) { logger.WriteLog(ex); throw ex; } }
public ActionResult InsertVendor(VendorDetail vendorDetail) { vendorDetail.UserName = Request.Form["uname"]; _context.VendorDetails.Add(vendorDetail); _context.SaveChanges(); var uD = new UsersDetail(); uD.UserName = Request.Form["uname"]; uD.UserPassword = encryptPassword(Request.Form["upass"]); uD.FullName = vendorDetail.Name; uD.PhoneNumber = vendorDetail.PhoneNumber; uD.RoleId = 6; _context.UsersDetails.Add(uD); _context.SaveChanges(); return(Redirect("~/Vendor/Index")); }
public ActionResult UpdateVendor(VendorDetail vendorDetail) { var vendorInDb = _context.VendorDetails.SingleOrDefault(v => v.VId.Equals(vendorDetail.VId)); vendorInDb.UserName = vendorDetail.UserName; vendorInDb.Address = vendorDetail.Address; vendorInDb.Name = vendorDetail.Address; vendorInDb.Email = vendorDetail.Address; vendorInDb.PhoneNumber = vendorDetail.PhoneNumber; _context.SaveChanges(); var uD = _context.UsersDetails.SingleOrDefault(u => u.UserName.Equals(vendorDetail.UserName)); uD.UserPassword = encryptPassword(Request.Form["upass"]); _context.SaveChanges(); return(Redirect("~/Vendor/Index")); }
public VendorDetailsModel GetVendorDetails(long Id) { VendorDetailsModel objModel = new VendorDetailsModel(); using (ShopDevEntities db = new ShopDevEntities()) { try { VendorDetail vendor = GetVendor(db, Id); vendor.CopyProperties(objModel); } catch (Exception) { } } return objModel; }
public IActionResult Post(string username, [FromBody] ProductItem obj) { HttpResponseMessage response = client.GetAsync(client.BaseAddress + "api/vendor/" + obj.Id).Result; if (response.IsSuccessStatusCode) { string data = JsonConvert.SerializeObject(response); VendorDetail vendor = JsonConvert.DeserializeObject <VendorDetail>(data); CartItemRepo cartrepo = new CartItemRepo(); if (cartrepo.PostCartItem(username, obj, vendor)) { return(Ok()); } return(BadRequest()); } return(BadRequest()); }
public void Save(DCVendor dcvdr) { try { VendorDetail detvdr = new VendorDetail(); GMUtilities.GMReflectionUtils.Copy(dcvdr, detvdr); m_biz.Save(detvdr); foreach (DCVendorCountyRate vcr in dcvdr.CountyRate) { vcr.VendorID = detvdr.ID; m_crf.Save(vcr); } dcvdr.ID = detvdr.ID; } catch (Exception exp) { throw exp; } finally { } }
public async Task <IActionResult> Post(VendorDetail vendorDetail) { if (!ModelState.IsValid) { return(ModelError()); } var user = await GetCurrentUser(); vendorDetail.OrganizationId = user.OrganizationId; var createResponse = await _vendorService.CreateVendorAsync(vendorDetail, user.Id); if (!createResponse.IsSuccess) { return(BadRequest(createResponse)); } return(Ok(createResponse)); }
public async Task <IActionResult> Put(VendorDetail vendorDetail) { if (!ModelState.IsValid) { return(BadRequest("Model has some errors")); } var user = await GetCurrentUser(); vendorDetail.OrganizationId = user.OrganizationId; var updateResponse = await _vendorService.UpdateVendorAsync(vendorDetail, user.Id); if (!updateResponse.IsSuccess) { return(BadRequest(updateResponse)); } return(Ok(updateResponse)); }
public bool PostCartItem(string username, ProductItem pitem, VendorDetail vdetail) { CartItem cItem = new CartItem(); cItem.UserName = username; cItem.ProductName = pitem.Name; cItem.Price = pitem.Price; cItem.Description = pitem.Description; cItem.VendorName = vdetail.Name; cItem.DeliveryCharge = vdetail.DeliveryCharge; //date has been taken by default as vendor does not return date as discribed in document...... cItem.DeliveryDate = DateTime.Parse("12-10-2020"); if (pitem.IsAvailable == true) { cartlist.Add(cItem); return(true); } return(false); }
/// <summary> /// CreateVendor Method inserts new record in Vendor table and also updates Note table if there is a note /// </summary> /// <param name="vendorObject"></param> /// <param name="userId"></param> /// <returns>int</returns> public int CreateVendor(int userId, VendorObject vendorObject) { //define method execution return value to be false by default int retMthdExecResult = 0; int distillerID = _dl.GetDistillerId(userId); if (vendorObject != null) { try { Vendor tbl = new Vendor(); tbl.Name = vendorObject.VendorName; tbl.DistillerID = distillerID; _db.Vendor.Add(tbl); _db.SaveChanges(); VendorDetail tbl1 = new VendorDetail(); if (vendorObject.Note != string.Empty && vendorObject.Note != null) { tbl1.Note = vendorObject.Note; } tbl1.VendorID = tbl.VendorID; _db.VendorDetail.Add(tbl1); _db.SaveChanges(); retMthdExecResult = tbl.VendorID; } catch (Exception e) { retMthdExecResult = 0; throw e; } } else { retMthdExecResult = 0; } return(retMthdExecResult); }
public async Task <EntityApiResponse <VendorDetail> > UpdateVendorAsync(VendorDetail vendorDetail, string currentUserId) { if (vendorDetail is null) { throw new ArgumentNullException(nameof(vendorDetail)); } var vendor = await _vendorRepository.GetByIdAsync(vendorDetail.Id); if (vendor is null) { return(new EntityApiResponse <VendorDetail>(error: "Vendor does not exist")); } var country = await _countryRepository.GetByIdAsync(vendorDetail.Country.Id); if (country is null) { return(new EntityApiResponse <VendorDetail>(error: "Country does not exist")); } vendor.FirstName = vendorDetail.FirstName.Trim(); vendor.LastName = vendorDetail.LastName.Trim(); vendor.Note = vendorDetail.Note.Trim(); vendor.Phone = vendorDetail.Phone.Trim(); vendor.Telephone = vendorDetail.Telephone.Trim(); vendor.Website = vendorDetail.Website.Trim(); vendor.Address1 = vendorDetail.Address1.Trim(); vendor.Address2 = vendorDetail.Address2.Trim(); vendor.City = vendorDetail.City.Trim(); vendor.Email = vendorDetail.Email.Trim(); vendor.ModifiedById = currentUserId; vendor.LastModifiedDate = DateTime.UtcNow; vendor.CountryId = country.Id; await _vendorRepository.UpdateAsync(vendor); return(new EntityApiResponse <VendorDetail>(entity: new VendorDetail(vendor))); }
/// <summary> /// Mapping vendor details from SAP to /// DB company table object /// </summary> /// <param name="vendorDetail"></param> /// <returns></returns> public Company MapCompany(VendorDetail vendorDetail) { try { Company company = new Company(); company.Company_name = vendorDetail.CompanyName; company.Password = vendorDetail.Password; company.InterestedAs = vendorDetail.InstretedAs; company.Pan_number = vendorDetail.PanNumber; company.Contact_Name = vendorDetail.ContactName; company.Contact_Designation = vendorDetail.ContactDesignation; company.Contact_email = vendorDetail.ContactEmail; company.Contact_mobile = vendorDetail.ContactMobile; company.CreatedBy = 56789; return(company); } catch (Exception ex) { logger.WriteLog(ex); throw ex; } }
/// <summary> /// Getting single vendor from SAP /// Date: 20 June 2019 /// Developer: Shreyans Khandelwal(0538) /// </summary> /// <returns></returns> public VendorDetail GetVendor() { VendorDetail vendorDetModel = new VendorDetail(); try { SAPCommonService objSAPCommon = new SAPCommonService(); RfcDestination rfcDest = RfcDestinationManager.TryGetDestination("accelyides"); if (rfcDest == null) { RfcDestinationManager.RegisterDestinationConfiguration(objSAPCommon); rfcDest = RfcDestinationManager.GetDestination("accelyides"); } vendorDetModel = GetVendorDetail(rfcDest); return(vendorDetModel); } catch (Exception ex) { logger.WriteLog(ex); throw ex; } }
public async Task <EntityApiResponse <VendorDetail> > CreateVendorAsync(VendorDetail vendorDetail, string currentUserId) { if (vendorDetail is null) { throw new ArgumentNullException(nameof(vendorDetail)); } var country = await _countryRepository.GetByIdAsync(vendorDetail.Country.Id); if (country is null) { return(new EntityApiResponse <VendorDetail>(error: "Country does not exist")); } var newVendor = new Vendor { FirstName = vendorDetail.FirstName.Trim(), LastName = vendorDetail.LastName.Trim(), Email = vendorDetail.Email.Trim(), Address1 = vendorDetail.Address1.Trim(), Address2 = vendorDetail.Address2.Trim(), Note = vendorDetail.Note.Trim(), City = vendorDetail.City.Trim(), CountryId = country.Id, CreatedById = currentUserId, ModifiedById = currentUserId, Website = vendorDetail.Website.Trim(), Telephone = vendorDetail.Telephone.Trim(), Phone = vendorDetail.Phone.Trim(), OrganizationId = vendorDetail.OrganizationId }; await _vendorRepository.InsertAsync(newVendor); return(new EntityApiResponse <VendorDetail>(entity: new VendorDetail(newVendor))); }
public void Save(VendorDetail det) { Save(det, VendorMap.ProcedureSave); }
private void buttonSave_Click(object sender, EventArgs e) { if (!ValidateForm()) return; SaveRecord(); _vendor = new VendorDetail() { VendorType = _vendorType.ToString(), ProcessedDate = DateTime.Now.Date }; ResetControls(); if (!_isNewRecord) Close(); }
public void Save(VendorDetail det) { m_db.Save(det); }
public VendorDetail GetVendorDetailsById(int id) { VendorDetail vendorDetail = _vendorRepository.GetVendorDetailsById(id); return(vendorDetail); }
public IHttpActionResult Get(string txt) { SerkoResponse resp = new SerkoResponse() { response = new Response() { Vendor = new VendorDetail() }, status = new Status() { success = false, detail = new Detail() { } } }; VendorDetail Vendor = new VendorDetail { Expense = new ExpenseDetail() }; try { // add xml tags to make it standard xml document txt = "<?xml version='1.0' encoding='utf-8' ?> " + "<body>" + txt + "</body>"; // remove emails addresses from the text as it has '<' and '>' which is interpreted as tags txt = Utility.RemoveEmails(txt); XDocument xmldoc = XDocument.Load(new System.IO.StringReader(txt)); var odata = from o in xmldoc.Elements("body") select o; double total, gst, amount; bool IsTotalNull = false; foreach (var item in odata) { if (item.Element("vendor") != null) { Vendor.Vendor = item.Element("vendor").Value; } if (item.Element("description") != null) { Vendor.Description = item.Element("description").Value; } if (item.Element("date") != null) { Vendor.Date = item.Element("date").Value; } var odata1 = from o in item.Elements("expense") select o; foreach (var item1 in odata1) { if (item1.Element("cost_centre") != null) { Vendor.Expense.CostCentre = item1.Element("cost_centre").Value; } if (string.IsNullOrEmpty(Vendor.Expense.CostCentre)) { Vendor.Expense.CostCentre = "UNKNOWN"; } if (item1.Element("payment_method") != null) { Vendor.Expense.PaymentMethod = item1.Element("payment_method").Value; } if (item1.Element("total") != null) { total = Convert.ToDouble(item1.Element("total").Value); Vendor.Expense.Total = total; amount = total / 1.1; //10% gst gst = total - amount; Vendor.Expense.Amount = amount; Vendor.Expense.GST = gst; } else { IsTotalNull = true; } } } resp.response.Vendor = Vendor; if (IsTotalNull) { resp.status.success = false; resp.status.detail = new Detail { errormessage = " total is null" }; } else { resp.status.success = true; } } catch (Exception) { resp.status.success = false; resp.status.detail = new Detail { errormessage = "problem with strating or ending tags " }; resp.response.Vendor = Vendor; } return(Ok(resp)); }
public VendorDetail GetVenderbyId(int ProductId) { VendorDetail obj = vendors.Where(x => x.Id == ProductId).FirstOrDefault(); return(obj); }