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}");
}
}
}
