public ActionResult GetCustomerFullData(string Code, string Type) { Models.Customer.CustomerModel custModel = new Models.Customer.CustomerModel(); custModel.custRecord = SetCustomerRecordModel(service.getCustomerRecordByCode(Code)); var ID = custModel.custRecord.ID; if (Type == "Character") { custModel.custCharacter = setCustomerCharacterModel(service.getCustomerCharacterByID(ID)); } if (Type == "Education") { custModel.custEducation = setCustomerEducationModel(service.getCustomerEducationByID(ID)); } if (Type == "Dependent") { custModel.custDependents = setCustomerDependentModel(service.getCustomerDependentsByID(ID)); } if (Type == "Address") { custModel.custAddress = setCustomerAddressModel(service.getCustomerAddressByID(ID)); } if (Type == "Employment") { custModel.custEmployment = setCustomerEmploymentModel(service.getCustomerEmploymentRecordByID(ID)); } return(Json(custModel, JsonRequestBehavior.AllowGet)); }
public CompanyCustomer.Models.Customer.CustomerModel GetCustomerByProvider(string ProviderPublicId, string vCustomerRelated) { List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>(); lstParams.Add(DataInstance.CreateTypedParameter("vProviderPublicId", ProviderPublicId)); lstParams.Add(DataInstance.CreateTypedParameter("vCustomerRelated", vCustomerRelated)); ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest() { CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable, CommandText = "CC_GetCustomerByProvider", CommandType = System.Data.CommandType.StoredProcedure, Parameters = lstParams, }); CompanyCustomer.Models.Customer.CustomerModel oReturn = new Models.Customer.CustomerModel(); if (response.DataTableResult != null && response.DataTableResult.Rows.Count > 0) { oReturn = new Models.Customer.CustomerModel() { RelatedProvider = (from cpri in response.DataTableResult.AsEnumerable() where !cpri.IsNull("CustomerPublicId") group cpri by new { CustomerProviderId = cpri.Field <UInt64>("CustomerProviderId"), CustomerPublicId = cpri.Field <string>("CustomerPublicId"), CustomerName = cpri.Field <string>("CustomerName"), StatusId = cpri.Field <UInt64>("StatusId"), StatusName = cpri.Field <string>("StatusName"), IsRelatedCustomer = cpri.Field <UInt64>("IsRelatedCustomer") == 1 ? true : false, } into cprinf select new ProveedoresOnLine.CompanyCustomer.Models.Customer.CustomerProviderModel() { CustomerProviderId = Convert.ToInt32(cprinf.Key.CustomerProviderId), RelatedProvider = new Company.Models.Company.CompanyModel() { CompanyPublicId = cprinf.Key.CustomerPublicId, CompanyName = cprinf.Key.CustomerName, }, Status = new Company.Models.Util.CatalogModel() { ItemId = Convert.ToInt32(cprinf.Key.StatusId), ItemName = cprinf.Key.StatusName, }, Enable = cprinf.Key.IsRelatedCustomer, }).ToList(), }; } return(oReturn); }
public void AditionalDocumentsUpsert() { ProveedoresOnLine.CompanyCustomer.Models.Customer.CustomerModel oModel = new Models.Customer.CustomerModel(); ProveedoresOnLine.Company.Models.Util.GenericItemModel oGenericModel = new ProveedoresOnLine.Company.Models.Util.GenericItemModel(); oModel.RelatedCompany = new Company.Models.Company.CompanyModel(); oModel.RelatedCompany.CompanyPublicId = "DA5C572E"; oModel.AditionalDocuments = new List <Company.Models.Util.GenericItemModel>(); oGenericModel = new Company.Models.Util.GenericItemModel() { ItemId = 0, ItemName = "Archivo adicional de prueba", Enable = true, ItemInfo = new List <Company.Models.Util.GenericItemInfoModel>(), }; oGenericModel.ItemInfo.Add( new Company.Models.Util.GenericItemInfoModel() { ItemInfoId = 0, ItemInfoType = new Company.Models.Util.CatalogModel() { ItemId = 220003, }, Value = "1701001", Enable = true, }); oGenericModel.ItemInfo.Add( new Company.Models.Util.GenericItemInfoModel() { ItemInfoId = 0, ItemInfoType = new Company.Models.Util.CatalogModel() { ItemId = 220004, }, Value = "701001", Enable = true, } ); oModel.AditionalDocuments.Add(oGenericModel); oModel = ProveedoresOnLine.CompanyCustomer.Controller.CompanyCustomer.AditionalDocumentsUpsert(oModel); Assert.AreEqual(true, oModel != null && oModel.AditionalDocuments != null); }
public ActionResult Update_CustomerRecord(string Code) { Models.Customer.CustomerModel custModel = new Models.Customer.CustomerModel(); var custRecord = service.getCustomerRecordByCode(Code); custModel.custRecord = SetCustomerRecordModel(custRecord); var ID = custModel.custRecord.ID; custModel.custCharacter = setCustomerCharacterModel(service.getCustomerCharacterByID(ID)); custModel.custEducation = setCustomerEducationModel(service.getCustomerEducationByID(ID)); custModel.custDependents = setCustomerDependentModel(service.getCustomerDependentsByID(ID)); custModel.custAddress = setCustomerAddressModel(service.getCustomerAddressByID(ID)).Where(p => p.AddressTypeID.Contains("0")).ToList(); custModel.custEmployment = setCustomerEmploymentModel(service.getCustomerEmploymentRecordByID(ID)); custModel.allComponents = setComponents(custRecord); return(View(custModel)); }
public ActionResult FetchCustomerRecordByID(string Code) { Models.Customer.CustomerModel custModel = new Models.Customer.CustomerModel(); custModel.custRecord = SetCustomerRecordModel(service.getCustomerRecordByCode(Code)); var ID = custModel.custRecord.ID; custModel.custCharacter = setCustomerCharacterModel(service.getCustomerCharacterByID(ID)); custModel.custEducation = setCustomerEducationModel(service.getCustomerEducationByID(ID)); custModel.custDependents = setCustomerDependentModel(service.getCustomerDependentsByID(ID)); custModel.custAddress = setCustomerAddressModel(service.getCustomerAddressByID(ID)); custModel.custEmployment = setCustomerEmploymentModel(service.getCustomerEmploymentRecordByID(ID)); var pvr = new PartialViewResult(); pvr = PartialView("_Display_CustomerRecord", custModel); return(pvr); }
public ActionResult AddCustomerData(Models.Customer.CustomerModel custModel, List <Models.Customer.CustomerAddress> custAddress, List <Models.Customer.CustomerDependents> custDependents, List <Models.Customer.CustomerEmployment> custEmployment, List <Models.Customer.CustomerEducation> custEducation, List <Models.Customer.CustomerCharacter> custCharacter, string PISID) { if (custEmployment == null) { custEmployment = new List <Models.Customer.CustomerEmployment>(); } if (custCharacter == null) { custCharacter = new List <Models.Customer.CustomerCharacter>(); } if (custDependents == null) { custDependents = new List <Models.Customer.CustomerDependents>(); } if (custEducation == null) { custEducation = new List <Models.Customer.CustomerEducation>(); } if (custAddress == null) { custAddress = new List <Models.Customer.CustomerAddress>(); } custModel.custEmployment = custEmployment; custModel.custCharacter = custCharacter; custModel.custDependents = custDependents; custModel.custEducation = custEducation; foreach (Models.Customer.CustomerAddress address in custAddress) { custModel.custAddress.Add(address); } Mapper.CreateMap <Models.Customer.CustomerAddress, BusinessObjects.CustomerAddress>(); Mapper.CreateMap <Models.Customer.CustomerCharacter, BusinessObjects.CustomerCharacter>(); Mapper.CreateMap <Models.Customer.CustomerDependents, BusinessObjects.CustomerDependents>(); Mapper.CreateMap <Models.Customer.CustomerEducation, BusinessObjects.CustomerEducation>(); Mapper.CreateMap <Models.Customer.CustomerEmployment, BusinessObjects.CustomerEmployment>(); Mapper.CreateMap <Models.Customer.CustomerRecord, BusinessObjects.CustomerRecord>(); Mapper.CreateMap <Models.Customer.CustomerModel, BusinessObjects.CustomerModel>(); BusinessObjects.CustomerModel cModel = Mapper.Map <Models.Customer.CustomerModel, BusinessObjects.CustomerModel>(custModel); List <Dictionary <string, object> > session = (List <Dictionary <string, object> >)Session["loginDetails"]; string UserID = session[0]["ID"].ToString(); cModel.custRecord.PreparedByID = UserID; cModel.custRecord.DocumentStatusCode = "7"; cModel.custRecord.Permission = "5"; return(Content(service.UpdateCustomerData("Add", cModel, PISID).ToString())); }
public ActionResult Add_CustomerRecord() { Models.Customer.CustomerModel custModel = new Models.Customer.CustomerModel(); BusinessObjects.CustomerRecord custRecord = new BusinessObjects.CustomerRecord(); Models.Customer.CustomerRecord CMcustRecord = new Models.Customer.CustomerRecord(); List <Models.Customer.CustomerAddress> LCustAddress = new List <Models.Customer.CustomerAddress>(); Models.Customer.CustomerAddress McustAddress = new Models.Customer.CustomerAddress(); LCustAddress.Add(McustAddress); custModel.custRecord = CMcustRecord; custModel.custAddress = LCustAddress; var PISID = System.Guid.NewGuid().ToString(); custModel.custRecord.ID = PISID; custModel.custAddress[0].ID = System.Guid.NewGuid().ToString(); custModel.custAddress[0].PISID = PISID; custModel.custAddress[0].AddressTypeID = "0"; custModel.allComponents = setComponents(custRecord); return(View(custModel)); }
public ActionResult UpdateCustomerData(Models.Customer.CustomerModel custModel, List <Models.Customer.CustomerAddress> custAddress, List <Models.Customer.CustomerDependents> custDependents, List <Models.Customer.CustomerEmployment> custEmployment, List <Models.Customer.CustomerEducation> custEducation, List <Models.Customer.CustomerCharacter> custCharacter, string PISID) { if (custEmployment == null) { custEmployment = new List <Models.Customer.CustomerEmployment>(); } if (custCharacter == null) { custCharacter = new List <Models.Customer.CustomerCharacter>(); } if (custDependents == null) { custDependents = new List <Models.Customer.CustomerDependents>(); } if (custEducation == null) { custEducation = new List <Models.Customer.CustomerEducation>(); } if (custAddress == null) { custAddress = new List <Models.Customer.CustomerAddress>(); } custModel.custEmployment = custEmployment; custModel.custCharacter = custCharacter; custModel.custDependents = custDependents; custModel.custEducation = custEducation; foreach (Models.Customer.CustomerAddress address in custAddress) { custModel.custAddress.Add(address); } Mapper.CreateMap <Models.Customer.CustomerAddress, BusinessObjects.CustomerAddress>(); Mapper.CreateMap <Models.Customer.CustomerCharacter, BusinessObjects.CustomerCharacter>(); Mapper.CreateMap <Models.Customer.CustomerDependents, BusinessObjects.CustomerDependents>(); Mapper.CreateMap <Models.Customer.CustomerEducation, BusinessObjects.CustomerEducation>(); Mapper.CreateMap <Models.Customer.CustomerEmployment, BusinessObjects.CustomerEmployment>(); Mapper.CreateMap <Models.Customer.CustomerRecord, BusinessObjects.CustomerRecord>(); Mapper.CreateMap <Models.Customer.CustomerModel, BusinessObjects.CustomerModel>(); BusinessObjects.CustomerModel cModel = Mapper.Map <Models.Customer.CustomerModel, BusinessObjects.CustomerModel>(custModel); return(Content(service.UpdateCustomerData("Update", cModel, PISID).ToString())); }
public Models.Customer.CustomerModel GetAditionalDocumentsByCompany(string CustomerPublicId, bool Enable, int PageNumber, int RowCount, out int TotalRows) { TotalRows = 0; List <IDbDataParameter> lstParams = new List <IDbDataParameter>(); lstParams.Add(DataInstance.CreateTypedParameter("vCustomerPublicId", CustomerPublicId)); lstParams.Add(DataInstance.CreateTypedParameter("vEnable", Enable)); lstParams.Add(DataInstance.CreateTypedParameter("vPageNumber", PageNumber)); lstParams.Add(DataInstance.CreateTypedParameter("vRowCount", RowCount)); ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest() { CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable, CommandText = "CC_GetAditionalDocumentsByCompanyPublicId", CommandType = CommandType.StoredProcedure, Parameters = lstParams, }); Models.Customer.CustomerModel oReturn = null; if (response.DataTableResult != null && response.DataTableResult.Rows.Count > 0) { TotalRows = response.DataTableResult.Rows[0].Field <int>("oTotalRows"); oReturn = new Models.Customer.CustomerModel() { RelatedCompany = new Company.Models.Company.CompanyModel() { CompanyPublicId = response.DataTableResult.Rows[0].Field <string>("CustomerPublicId"), }, AditionalDocuments = (from ad in response.DataTableResult.AsEnumerable() where !ad.IsNull("AditionalDocumentId") group ad by new { AditionalDocumentId = ad.Field <int>("AditionalDocumentId"), AditionalDocumentName = ad.Field <string>("AditionalDocumentName"), AditionalDocumnetEnable = ad.Field <UInt64>("AditionalDocumentEnable"), } into adi select new ProveedoresOnLine.Company.Models.Util.GenericItemModel() { ItemId = adi.Key.AditionalDocumentId, ItemName = adi.Key.AditionalDocumentName, Enable = adi.Key.AditionalDocumnetEnable == 1 ? true : false, ItemInfo = (from adinf in response.DataTableResult.AsEnumerable() where !adinf.IsNull("AditionalDocumentInfoId") && adinf.Field <int>("AditionalDocumentId") == adi.Key.AditionalDocumentId group adinf by new { AditionalDocumentInfoId = adinf.Field <int>("AditionalDocumentInfoId"), AditionalDocumentInfoTypeId = adinf.Field <int>("AditionalDocumentInfoTypeId"), AditionalDocumentInfoTypeName = adinf.Field <string>("AditionalDocumentInfoTypeName"), AditionalDocumentInfoValue = adinf.Field <string>("AditionalDocumentInfoValue"), AditionalDocumentInfoLargeValue = adinf.Field <string>("AditionalDocumentInfoLargeValue"), AditionalDocumentInfoEnable = adinf.Field <UInt64>("AditionalDocumentInfoEnable"), } into adinfi select new ProveedoresOnLine.Company.Models.Util.GenericItemInfoModel() { ItemInfoId = adinfi.Key.AditionalDocumentInfoId, ItemInfoType = new Company.Models.Util.CatalogModel() { ItemId = adinfi.Key.AditionalDocumentInfoTypeId, ItemName = adinfi.Key.AditionalDocumentInfoTypeName, }, Value = adinfi.Key.AditionalDocumentInfoValue, LargeValue = adinfi.Key.AditionalDocumentInfoLargeValue, Enable = adinfi.Key.AditionalDocumentInfoEnable == 1 ? true : false, }).ToList(), }).ToList(), }; } return(oReturn); }
public CompanyCustomer.Models.Customer.CustomerModel GetCustomerInfoByProvider(int CustomerProviderId, bool Enable, int PageNumber, int RowCount, out int TotalRows) { TotalRows = 0; List <System.Data.IDbDataParameter> lstParams = new List <IDbDataParameter>(); lstParams.Add(DataInstance.CreateTypedParameter("vCustomerProviderId", CustomerProviderId)); lstParams.Add(DataInstance.CreateTypedParameter("vEnable", Enable == true ? 1 : 0)); lstParams.Add(DataInstance.CreateTypedParameter("vPageNumber", PageNumber)); lstParams.Add(DataInstance.CreateTypedParameter("vRowCount", RowCount)); ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest() { CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable, CommandText = "CC_GetCustomerInfoByProvider", CommandType = CommandType.StoredProcedure, Parameters = lstParams, }); CompanyCustomer.Models.Customer.CustomerModel oReturn = null; if (response.DataTableResult != null && response.DataTableResult.Rows.Count > 0) { TotalRows = response.DataTableResult.Rows[0].Field <int>("TotalRows"); oReturn = new Models.Customer.CustomerModel() { RelatedProvider = new List <Models.Customer.CustomerProviderModel>() { new Models.Customer.CustomerProviderModel() { CustomerProviderId = response.DataTableResult.Rows[0].Field <int>("CustomerProviderId"), CustomerProviderInfo = (from cpi in response.DataTableResult.AsEnumerable() where !cpi.IsNull("CustomerProviderInfoId") group cpi by new { CustomerProviderInfoId = cpi.Field <int>("CustomerProviderInfoId"), TrackingId = cpi.Field <int>("TrackingId"), TrackingName = cpi.Field <string>("TrackingName"), TrackingValue = cpi.Field <string>("TrackingValue"), Enable = cpi.Field <UInt64>("Enable") == 1 ? true : false, CreateDate = cpi.Field <DateTime>("CreateDate"), } into cpinf select new ProveedoresOnLine.Company.Models.Util.GenericItemInfoModel() { ItemInfoId = cpinf.Key.CustomerProviderInfoId, ItemInfoType = new Company.Models.Util.CatalogModel() { ItemId = cpinf.Key.TrackingId, ItemName = cpinf.Key.TrackingName, }, LargeValue = cpinf.Key.TrackingValue, Enable = cpinf.Key.Enable, CreateDate = cpinf.Key.CreateDate, }).ToList() } } }; } return(oReturn); }