/// <summary> /// Takes the specified budget source property. /// </summary> /// <param name="vendor">The vendor.</param> /// <returns></returns> private object[] Take(VendorEntity vendor) { return(new object[] { "@VendorID", vendor.VendorId , "@VendorCode", vendor.VendorCode , "@VendorName", vendor.VendorName , "@Address", vendor.Address , "@ContactName", vendor.ContactName , "@ContactRegency", vendor.ContactRegency , "@Phone", vendor.Phone , "@Mobile", vendor.Mobile , "@Fax", vendor.Fax , "@Email", vendor.Email , "@TaxCode", vendor.TaxCode , "@Website", vendor.Website , "@Province", vendor.Province , "@City", vendor.City , "@ZipCode", vendor.ZipCode , "@Area", vendor.Area , "@Country", vendor.Country , "@BankNumber", vendor.BankNumber , "@BankName", vendor.BankName , "@BankID", vendor.BankId , "@IsActive", vendor.IsActive }); }
/// <summary> /// Deletes the specified object. /// </summary> /// <param name="vendorEntity">The vendor entity.</param> /// <returns></returns> public string DeleteVendor(VendorEntity vendorEntity) { const string sql = @"uspDelete_Vendor"; object[] parms = { "@VendorID", vendorEntity.VendorId }; return(Db.Delete(sql, true, parms)); }
protected BusinessEntityEntity(SerializationInfo info, StreamingContext context) : base(info, context) { if (SerializationHelper.Optimization != SerializationOptimization.Fast) { _businessEntityAddresses = (EntityCollection <BusinessEntityAddressEntity>)info.GetValue("_businessEntityAddresses", typeof(EntityCollection <BusinessEntityAddressEntity>)); _businessEntityContacts = (EntityCollection <BusinessEntityContactEntity>)info.GetValue("_businessEntityContacts", typeof(EntityCollection <BusinessEntityContactEntity>)); _person = (PersonEntity)info.GetValue("_person", typeof(PersonEntity)); if (_person != null) { _person.AfterSave += new EventHandler(OnEntityAfterSave); } _vendor = (VendorEntity)info.GetValue("_vendor", typeof(VendorEntity)); if (_vendor != null) { _vendor.AfterSave += new EventHandler(OnEntityAfterSave); } _store = (StoreEntity)info.GetValue("_store", typeof(StoreEntity)); if (_store != null) { _store.AfterSave += new EventHandler(OnEntityAfterSave); } this.FixupDeserialization(FieldInfoProviderSingleton.GetInstance()); } // __LLBLGENPRO_USER_CODE_REGION_START DeserializationConstructor // __LLBLGENPRO_USER_CODE_REGION_END }
public VendorEntity Get(Guid VendorId) { Vendor Vendor = vendorRepository.Get(VendorId); if (Vendor == null) { return(null); } VendorEntity VendorEntity = new VendorEntity(Vendor); return(VendorEntity); }
/// <summary> /// AddUpdateVendorDetails /// </summary> /// <param name="data"></param> /// <returns></returns> public CommonResponse AddUpdateVendorDetails(VendorEntity data) { CommonResponse obj = new CommonResponse(); try { var check = db.UnitworkccsTblvendor.Where(m => m.VendorId == data.vendorId && m.IsDeleted == 0).FirstOrDefault(); if (check == null) { UnitworkccsTblvendor UnitworkccsTblvendordet = new UnitworkccsTblvendor(); UnitworkccsTblvendordet.Vendor = data.vendor; UnitworkccsTblvendordet.VendorName = data.vendorName; UnitworkccsTblvendordet.IsDeleted = 0; UnitworkccsTblvendordet.CreatedOn = DateTime.Now; UnitworkccsTblvendordet.CreatedBy = 1; db.UnitworkccsTblvendor.Add(UnitworkccsTblvendordet); db.SaveChanges(); obj.isStatus = true; obj.response = ResourceResponse.AddedSuccessMessage; } else { check.Vendor = data.vendor; check.VendorName = data.vendorName; check.ModifiedBy = 2; check.ModifiedOn = DateTime.Now; db.SaveChanges(); obj.isStatus = true; obj.response = ResourceResponse.UpdatedSuccessMessage; } } catch (Exception e) { log.Error(e); if (e.InnerException != null) { log.Error(e.InnerException.ToString()); } obj.isStatus = false; obj.response = ResourceResponse.FailureMessage; } return(obj); }
/// <summary> /// Gets all vendors. /// </summary> /// <returns> /// Get All Vendors /// </returns> public IEnumerable <VendorEntity> GetAllVendors() { IList <VendorEntity> result = new List <VendorEntity>(); IVendorBL vendorBL = new VendorBL(); List <Vendor> vendorList = vendorBL.GetAllVendor(); foreach (Vendor source in vendorList) { VendorEntity target = new VendorEntity(); target.VendorID = source.VendorID; target.Vendor = source.Vendor1; target.Address = source.AddressLine1; target.City = source.City; target.State = source.State; target.Country = source.Country; result.Add(target); } return(result); }
public static IVendor GetVendor(int ID) { string strExecution = "[mst].[spGetVendor]"; //List<IVendor> lstVnd = new List<IVendor>(); IVendor Vnd = null; using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddIntegerParam("@VendorId", ID); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { Vnd = new VendorEntity(reader); } reader.Close(); } return(Vnd); }
//private void CheckUserAccess() //{ // if (!ReferenceEquals(Session[Constants.SESSION_USER_INFO], null)) // { // IUser user = (IUser)Session[Constants.SESSION_USER_INFO]; // if (ReferenceEquals(user, null) || user.Id == 0) // { // Response.Redirect("~/Login.aspx"); // } // if (user.UserRole.Id != (int)UserRole.Admin) // { // Response.Redirect("~/Unauthorized.aspx"); // } // } // else // { // Response.Redirect("~/Login.aspx"); // } //} private void LoadData() { VendorEntity oVendor = (VendorEntity)VendorBLL.GetVendor(Convert.ToInt32(hdnVendorID.Value)); ddlVendorType.SelectedIndex = ddlVendorType.Items.IndexOf(ddlVendorType.Items.FindByValue(oVendor.VendorType)); if (ddlVendorType.SelectedItem.Text == "CFS/ICD" || ddlVendorType.SelectedItem.Text == "ICD") { txtCfsCode.Enabled = true; rfvCfdCode.Enabled = true; ddlTerminalCode.Enabled = true; } else { txtCfsCode.Enabled = false; rfvCfdCode.Enabled = false; ddlTerminalCode.Enabled = false; } ddlLocationID.SelectedIndex = Convert.ToInt32(ddlLocationID.Items.IndexOf(ddlLocationID.Items.FindByValue(oVendor.LocationName))); PopulateDropDown((int)Enums.DropDownPopulationFor.TerminalCode, ddlTerminalCode, Convert.ToInt32(ddlLocationID.SelectedValue)); ddlSalutation.SelectedIndex = Convert.ToInt32(ddlSalutation.Items.IndexOf(ddlSalutation.Items.FindByValue(oVendor.VendorSalutation.ToString()))); if (ddlTerminalCode.Items.Count > 0) { ddlTerminalCode.SelectedIndex = Convert.ToInt32(ddlTerminalCode.Items.IndexOf(ddlTerminalCode.Items.FindByValue(oVendor.Terminalid.ToString()))); } txtName.Text = oVendor.VendorName; txtAddress.Text = oVendor.VendorAddress; txtCfsCode.Text = oVendor.CFSCode; TxtTAN.Text = oVendor.TANo; TxtPAN.Text = oVendor.PAN; TxtACNo.Text = oVendor.AcNo; TxtAcType.Text = oVendor.AcType; TxtBankName.Text = oVendor.BankName; TxtIEC.Text = oVendor.IEC; TxtEmail.Text = oVendor.EmailID; TxtBIN.Text = oVendor.BIN; TxtMob.Text = oVendor.Mobile; TxtCP.Text = oVendor.CP; }
public static List <IVendor> GetVendor(SearchCriteria searchCriteria, int ID) { string strExecution = "[mst].[spGetVendor]"; List <IVendor> lstVnd = new List <IVendor>(); //using (DbQuery oDq = new DbQuery(strExecution)) //{ // //========================================================= // oDq.AddIntegerParam("@VendorId", ID); // oDq.AddVarcharParam("@SchName", 100, searchCriteria.LocAbbr); // oDq.AddVarcharParam("@SchLoc", 100, searchCriteria.LocName); // oDq.AddVarcharParam("@SortExpression", 4, searchCriteria.SortExpression); // oDq.AddVarcharParam("@SortDirection", 4, searchCriteria.SortDirection); // DataTable dtAdd = oDq.GetTable(); //} using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddIntegerParam("@VendorId", ID); oDq.AddVarcharParam("@SchName", 100, searchCriteria.LocAbbr); oDq.AddVarcharParam("@SchLoc", 100, searchCriteria.LocName); oDq.AddVarcharParam("@SortExpression", 10, searchCriteria.SortExpression); oDq.AddVarcharParam("@SortDirection", 4, searchCriteria.SortDirection); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { IVendor Vnd = new VendorEntity(reader); lstVnd.Add(Vnd); } reader.Close(); } return(lstVnd); }
public IEnumerable <VendorDto> GetVendor(VendorDto vendordto) { try { VendorEntity vendorEntity = new VendorEntity { login_entity = new LoginEntity { servername = vendordto.login_dto.servername, username = vendordto.login_dto.username, password = vendordto.login_dto.password, dBname = vendordto.login_dto.dBname }, }; return(_mapper.Map <IEnumerable <VendorEntity>, IEnumerable <VendorDto> > (_vendorRepository.GetAllVendor(vendorEntity))); } catch (Exception ex) { logCentral.Error("PODataAll", ex); throw; } }
public async Task<IActionResult> AddUpdateVendorDetails(VendorEntity data) { CommonResponse response = vendor.AddUpdateVendorDetails(data); return Ok(response); }
public VendorEntity Update(VendorEntity VendorEntity, Guid VendorId) { throw new NotImplementedException(); }
public Vendor(VendorEntity VendorEntity) : base(VendorEntity) { }
public VendorEntity Create(VendorEntity VendorEntity) { throw new NotImplementedException(); }
public int AddVendor(VendorEntity vendorEntity) { throw new NotImplementedException(); }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { oVendorBll = new VendorBLL(); oVendorEntity = new VendorEntity(); //oUserEntity = (UserEntity)Session[Constants.SESSION_USER_INFO]; // This section has been commented temporarily oVendorEntity.VendorType = ddlVendorType.SelectedValue; oVendorEntity.LocationID = Convert.ToInt32(ddlLocationID.SelectedValue); oVendorEntity.VendorSalutation = Convert.ToInt32(ddlSalutation.SelectedValue); oVendorEntity.VendorName = txtName.Text.Trim(); oVendorEntity.VendorAddress = txtAddress.Text.Trim(); oVendorEntity.CompanyID = 1;//Need to populate from data base. This will be the company ID of the currently loggedin user. oVendorEntity.VendorActive = true; oVendorEntity.AcNo = TxtACNo.Text; oVendorEntity.AcType = TxtAcType.Text; oVendorEntity.BankName = TxtBankName.Text; oVendorEntity.BIN = TxtBIN.Text; oVendorEntity.EmailID = TxtEmail.Text; oVendorEntity.IEC = TxtIEC.Text; oVendorEntity.Mobile = TxtMob.Text; oVendorEntity.TANo = TxtTAN.Text; oVendorEntity.PAN = TxtPAN.Text; oVendorEntity.CP = TxtCP.Text; oVendorEntity.CFSCode = txtCfsCode.Text.Trim(); if (ddlTerminalCode.Items.Count > 0 && ddlTerminalCode.SelectedIndex > 0) { oVendorEntity.Terminalid = Convert.ToInt32(ddlTerminalCode.SelectedValue); } if (hdnVendorID.Value == "0") // Insert { oVendorEntity.CreatedBy = _userId; // oUserEntity.Id; oVendorEntity.CreatedOn = DateTime.Today.Date; oVendorEntity.ModifiedBy = _userId; // oUserEntity.Id; oVendorEntity.ModifiedOn = DateTime.Today.Date; switch (oVendorBll.AddEditVndor(oVendorEntity)) { case 0: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00011"); break; case 1: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00009"); ClearAll(); break; } } else // Update { oVendorEntity.VendorId = Convert.ToInt32(hdnVendorID.Value); oVendorEntity.ModifiedBy = _userId;// oUserEntity.Id; oVendorEntity.ModifiedOn = DateTime.Today.Date; switch (oVendorBll.AddEditVndor(oVendorEntity)) { case 0: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00011"); break; case 1: Response.Redirect("~/MasterModule/vendor-list.aspx"); break; } } } }
/// <summary> /// Updates the specified object. /// </summary> /// <param name="vendorEntity">The vendor entity.</param> /// <returns></returns> public string UpdateVendor(VendorEntity vendorEntity) { const string sql = @"uspUpdate_Vendor"; return(Db.Update(sql, true, Take(vendorEntity))); }
/// <summary> /// Inserts the specified object. /// </summary> /// <param name="vendorEntity">The vendor entity.</param> /// <returns></returns> public int InsertVendor(VendorEntity vendorEntity) { const string sql = @"uspInsert_Vendor"; return(Db.Insert(sql, true, Take(vendorEntity))); }
public bool UpdateVendor(VendorEntity vendorEntity) { throw new NotImplementedException(); }
public VendorEntity Create([FromBody] VendorEntity VendorEntity) { return(VendorService.Create(VendorEntity)); }
public VendorEntity Update(Guid VendorId, [FromBody] VendorEntity VendorEntity) { return(VendorService.Update(VendorEntity, VendorId)); }