public int AddUpdateClientMappingDetails(ClientMapping model) { try { SqlParameter[] param = new SqlParameter[13]; param[0] = new SqlParameter("@ID", model.ID); param[1] = new SqlParameter("@ClientID", model.ClientID); param[2] = new SqlParameter("@SBUID", model.SBUID); param[3] = new SqlParameter("@RMId", model.RMId); param[4] = new SqlParameter("@SecondaryRMId", model.SecondaryRMId); param[5] = new SqlParameter("@BranchId", model.BranchId); param[6] = new SqlParameter("@ModelId", model.ModelId); param[7] = new SqlParameter("@HeadOfFamily", model.HeadOfFamily); param[8] = new SqlParameter("@KYCValid", model.KYCValid); param[9] = new SqlParameter("@KYCFormNo", model.KYCFormNo); param[10] = new SqlParameter("@EffectiveFrom", model.EffectiveFrom); param[11] = new SqlParameter("@EffectiveTo", model.EffectiveTo); param[12] = new SqlParameter("@UserID", GetUserID()); //param[12] = new SqlParameter("@UserID", Convert.ToInt32(GetUserID("RoleID"))); int i = new ADODataFunction().ExecuteNonQuery(Constants.Procedures.AddUpdateClientMappingDetails, param, CommandType.StoredProcedure); return(i); } catch (Exception ex) { return(0); } }
public BuildingGraphAPIClient(string endpointURL, ClientMapping clientMapping) { Endpoint = endpointURL; Mapping = clientMapping; Client = new BuildingGraphClient(Endpoint); }
public ClientMainViewModel() { ClientDetails = new ClientMain(); AddressDetails = new ClientAddresses(); BankDetails = new ClientBankDetails(); DepositryDetails = new ClientDepositoryDetails(); EquityBrokerDetails = new ClientEquityBrokerDetails(); PersonalDetails = new ClientPersonal(); SecondaryContactDetails = new ClientSecondaryContact(); MappingDetails = new ClientMapping(); }
public void Test_EF_EntityInheritance() { var evs = new List <AuditEventEntityFramework>(); Audit.EntityFramework.Configuration.Setup() .ForContext <ProjectContext>(c => c .IncludeEntityObjects() .IncludeIndependantAssociations()) .UseOptOut() .IgnoreAny(t => t.Name.EndsWith("Audit")); Audit.Core.Configuration.Setup() .UseDynamicProvider(_ => _.OnInsert(ev => { evs.Add(ev as AuditEventEntityFramework); })); using (var ctx = new ProjectContext("data source=localhost;initial catalog=inheritance_test;integrated security=true;")) { ctx.Database.CreateIfNotExists(); } var cm = new ClientMapping(); using (var db = new ProjectContext("data source=localhost;initial catalog=inheritance_test;integrated security=true;")) { cm.PropertyOne = "one"; cm.PropertyTwo = "two"; db.Mapping.Add(cm); db.SaveChanges(); } using (var ctx = new ProjectContext("data source=localhost;initial catalog=inheritance_test;integrated security=true;")) { ctx.Database.Delete(); } Assert.AreEqual(1, evs.Count); Assert.AreEqual(1, evs[0].EntityFrameworkEvent.Entries.Count); Assert.AreEqual("Mapping", evs[0].EntityFrameworkEvent.Entries[0].Table); Assert.AreEqual(3, evs[0].EntityFrameworkEvent.Entries[0].ColumnValues.Count); Assert.IsNotNull(evs[0].EntityFrameworkEvent.Entries[0].ColumnValues["Id"]); Assert.IsNotNull(evs[0].EntityFrameworkEvent.Entries[0].Entity); Assert.AreEqual(typeof(ClientMapping), evs[0].EntityFrameworkEvent.Entries[0].Entity.GetType()); Assert.AreEqual("one", evs[0].EntityFrameworkEvent.Entries[0].ColumnValues["PropertyOne"]); Assert.AreEqual("two", evs[0].EntityFrameworkEvent.Entries[0].ColumnValues["PropertyTwo"]); }
public ClientMapping GetMappingDetailData(long ID) { try { DataSet data = new DataSet(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID", ID); data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetMappingDetailsByID, param, CommandType.StoredProcedure); ClientMapping datas = data.Tables[0].AsEnumerable().Select(a => new ClientMapping { ID = a.Field <long>("ID") , ClientID = a.Field <long>("ClientID") , SBUID = a.Field <long>("SBUID") , RMId = a.Field <long>("RMId") , SecondaryRMId = a.Field <long>("SecondaryRMId") , BranchId = a.Field <long>("BranchId") , KYCFormNo = a.Field <string>("KYCFormNo") , ModelId = a.Field <int>("ModelId") , KYCValid = a.Field <bool>("KYCValid") , EffectiveFrom = a.Field <string>("EffectiveFrom") , EffectiveTo = a.Field <string>("EffectiveTo") , HeadOfFamily = a.Field <bool>("HeadOfFamily") }).FirstOrDefault(); return(datas); } catch (Exception ex) { return(null); } }
static GobchatChannelMapping() { var channels = new List <ChannelData>() { Map(ChatChannel.None, relevant: false), Map(ChatChannel.Say, FFXIVChatChannel.SAY), Map(ChatChannel.Emote, FFXIVChatChannel.EMOTE), Map(ChatChannel.Yell, FFXIVChatChannel.YELL), Map(ChatChannel.Shout, FFXIVChatChannel.SHOUT), Map(ChatChannel.TellSend, FFXIVChatChannel.TELL_SEND), Map(ChatChannel.TellRecieve, FFXIVChatChannel.TELL_RECIEVE), Map(ChatChannel.Party, FFXIVChatChannel.PARTY), Map(ChatChannel.Guild, FFXIVChatChannel.GUILD), Map(ChatChannel.Alliance, FFXIVChatChannel.ALLIANCE), Map(ChatChannel.NPC_Dialog, new [] { FFXIVChatChannel.NPC_TALK, FFXIVChatChannel.NPC_DIALOGUE }), Map(ChatChannel.AnimatedEmote, FFXIVChatChannel.ANIMATED_EMOTE), Map(ChatChannel.PartyFinder, FFXIVChatChannel.PARTYFINDER, relevant: false), Map(ChatChannel.Echo, FFXIVChatChannel.ECHO), Map(ChatChannel.Error, FFXIVChatChannel.ERROR), Map(ChatChannel.Random, new [] { FFXIVChatChannel.RANDOM_SELF, FFXIVChatChannel.RANDOM_PARTY, FFXIVChatChannel.RANDOM_OTHER }), Map(ChatChannel.Teleport, FFXIVChatChannel.TELEPORT, relevant: false), Map(ChatChannel.System, FFXIVChatChannel.SYSTEM, relevant: false), Map(ChatChannel.LinkShell_1, FFXIVChatChannel.LINKSHELL_1), Map(ChatChannel.LinkShell_2, FFXIVChatChannel.LINKSHELL_2), Map(ChatChannel.LinkShell_3, FFXIVChatChannel.LINKSHELL_3), Map(ChatChannel.LinkShell_4, FFXIVChatChannel.LINKSHELL_4), Map(ChatChannel.LinkShell_5, FFXIVChatChannel.LINKSHELL_5), Map(ChatChannel.LinkShell_6, FFXIVChatChannel.LINKSHELL_6), Map(ChatChannel.LinkShell_7, FFXIVChatChannel.LINKSHELL_7), Map(ChatChannel.LinkShell_8, FFXIVChatChannel.LINKSHELL_8), Map(ChatChannel.CrossWorldLinkShell_1, FFXIVChatChannel.WORLD_LINKSHELL_1), Map(ChatChannel.CrossWorldLinkShell_2, FFXIVChatChannel.WORLD_LINKSHELL_2), Map(ChatChannel.CrossWorldLinkShell_3, FFXIVChatChannel.WORLD_LINKSHELL_3), Map(ChatChannel.CrossWorldLinkShell_4, FFXIVChatChannel.WORLD_LINKSHELL_4), Map(ChatChannel.CrossWorldLinkShell_5, FFXIVChatChannel.WORLD_LINKSHELL_5), Map(ChatChannel.CrossWorldLinkShell_6, FFXIVChatChannel.WORLD_LINKSHELL_6), Map(ChatChannel.CrossWorldLinkShell_7, FFXIVChatChannel.WORLD_LINKSHELL_7), Map(ChatChannel.CrossWorldLinkShell_8, FFXIVChatChannel.WORLD_LINKSHELL_8), Map(ChatChannel.GobchatInfo), Map(ChatChannel.GobchatError), }; foreach (var channel in channels) { ChatMapping.Add(channel.ChatChannel, channel); foreach (var c in channel.ClientChannel) { ClientMapping.Add(c, channel); } } var expectedValues = Enum.GetValues(typeof(ChatChannel)); foreach (ChatChannel expectedChannel in expectedValues) { if (!ChatMapping.ContainsKey(expectedChannel)) //if there is a ChatChannel, there needs to be a mapping for config data { throw new ArgumentException($"No mapping for {expectedChannel}"); } } }