//public JsonResponse AddUpdateAccountDetails(List<ClientAccountList> model)
//{
// try
// {
// if (model != null && model.Count > 0)
// {
// DataTable dt = ConvertToDataTable(model);
// SqlParameter[] param = new SqlParameter[3];
// param[0] = new SqlParameter("@TableParam", dt);
// param[1] = new SqlParameter("@ClientID", model[0].ClientID);
// param[2] = new SqlParameter("@UserID", GetUserID());
// int i = new ADODataFunction().ExecuteNonQuery(Constants.Procedures.AddUpdateClientsAccounts, param, CommandType.StoredProcedure);
// // If it return was not equal to 0 then it affect some rows means data inserted.
// if (i != 0)
// {
// resp.Status = Constants.ResponseStatus.Success;
// resp.Message = Constants.Service.Data_insert_success;
// }
// // Else Show the error message.
// else
// {
// resp.Status = Constants.ResponseStatus.Failed;
// resp.Message = Constants.Service.Data_insert_failed;
// }
// }
// else
// {
// resp.Message = Constants.Service.Data_insert_failed;
// }
// }
// catch (Exception ex)
// {
// resp.Message = Constants.Service.Common_message;
// }
// return resp;
//}
public int AddUpdateClientPersonalDetails(ClientPersonal model)
{
try
{
SqlParameter[] param = new SqlParameter[17];
param[0] = new SqlParameter("@ID", model.ID);
param[1] = new SqlParameter("@ClientID", model.ClientID);
param[2] = new SqlParameter("@MaritalStatusID", model.MaritalStatusID);
param[3] = new SqlParameter("@MotherFirstName", model.MotherFirstName);
param[4] = new SqlParameter("@MotherLastName", model.MotherLastName);
param[5] = new SqlParameter("@AnualIncomeID", model.AnnualIncomeID);
param[6] = new SqlParameter("@TradingExperienceID", model.TradingExperienceID);
param[7] = new SqlParameter("@CommodityTradeClassificationID", model.CommodityTradeClassificationID);
param[8] = new SqlParameter("@IsPoliticalExperienceID", model.IsPoliticalExperienceID);
param[9] = new SqlParameter("@CitizenshipID", model.CitizenshipID);
param[10] = new SqlParameter("@ResidentialStatusID", model.ResidentialStatusID);
param[11] = new SqlParameter("@EducationID", model.EducationID);
param[12] = new SqlParameter("@SpouseOrFatherFirstName", model.SpouseOrFatherFirstName);
param[13] = new SqlParameter("@SpouseOrFatherLastName", model.SpouseOrFatherLastName);
param[14] = new SqlParameter("@MaidenFirstName", model.MaidenFirstName);
param[15] = new SqlParameter("@MaidenLastName", model.MaidenLastName);
param[16] = new SqlParameter("@UserID", GetUserID());
//param[16] = new SqlParameter("@UserID", Convert.ToInt32(GetUserID("RoleID")));
int i = new ADODataFunction().ExecuteNonQuery(Constants.Procedures.AddUpdateClientPersonalDetails, param, CommandType.StoredProcedure);
return(i);
}
catch (Exception ex)
{
return(0);
}
}
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 ClientPersonal GetPersonalDetailData(long ID)
{
try
{
DataSet data = new DataSet();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", ID);
data = new ADODataFunction().ExecuteDataset("Admin_GetPersonalDetailsByID", param, CommandType.StoredProcedure);
ClientPersonal datas = data.Tables[0].AsEnumerable().Select(a => new ClientPersonal
{
ID = a.Field <long>("ID")
,
ClientID = a.Field <long>("ClientID")
,
MotherFirstName = a.Field <string>("MotherFirstName")
,
MotherLastName = a.Field <string>("MotherLastName")
,
SpouseOrFatherFirstName = a.Field <string>("SpouseOrFatherFirstName")
,
SpouseOrFatherLastName = a.Field <string>("SpouseOrFatherLastName")
,
MaidenFirstName = a.Field <string>("MaidenFirstName")
,
MaidenLastName = a.Field <string>("MaidenLastName")
,
MaritalStatusID = a.Field <int>("MaritalStatusID")
,
AnnualIncomeID = a.Field <int>("AnualIncomeID")
,
CitizenshipID = a.Field <int>("CitizenshipID")
,
CommodityTradeClassificationID = a.Field <int>("CommodityTradeClassificationID")
,
EducationID = a.Field <int>("EducationID")
,
ResidentialStatusID = a.Field <int>("ResidentialStatusID")
,
TradingExperienceID = a.Field <int>("TradingExperienceID")
,
IsPoliticalExperienceID = a.Field <bool>("IsPoliticalExperienceID")
}).FirstOrDefault();
return(datas);
}
catch (Exception ex)
{
return(null);
}
}
public async void Update(ClientPersonal clientPersonal)
{
// conteawaitxt.ClientPersonal.Update(clientPersonal);
//await context.SaveChangesAsync();
}
/// <summary>
/// Packets handled in this function could possibly be overriden by a plugin
/// </summary>
internal void HandleOverridePacket(PacketEventArgs e)
{
switch ((AresId)e.Packet.Id)
{
case AresId.MSG_CHAT_CLIENT_PUBLIC:
ClientPublic pub = (ClientPublic)e.Packet;
if (!string.IsNullOrEmpty(pub.Message))
{
server.SendPacket((s) =>
s.Vroom == Vroom &&
s.CanSee(this) &&
!s.Ignored.Contains(Name),
new ServerPublic(Name, pub.Message));
}
break;
case AresId.MSG_CHAT_CLIENT_EMOTE:
ClientEmote emote = (ClientEmote)e.Packet;
if (!string.IsNullOrEmpty(emote.Message))
{
server.SendPacket((s) =>
s.Vroom == Vroom &&
s.CanSee(this) &&
!s.Ignored.Contains(Name),
new ServerEmote(Name, emote.Message));
}
break;
case AresId.MSG_CHAT_CLIENT_PVT: {
Private priv = (Private)e.Packet;
if (string.IsNullOrEmpty(priv.Message))
{
return;
}
IClient target = server.FindUser((s) => s.Name == priv.Username);
if (target != null)
{
if (target.Ignored.Contains(Name))
{
SendPacket(new IgnoringYou(priv.Username));
}
else
{
priv.Username = Name;
server.SendPacket(target, priv);
}
}
else
{
SendPacket(new Offline(priv.Username));
}
}
break;
case AresId.MSG_CHAT_CLIENT_PERSONAL_MESSAGE:
ClientPersonal personal = (ClientPersonal)e.Packet;
Message = personal.Message;
break;
case AresId.MSG_CHAT_CLIENT_AVATAR:
ClientAvatar avatar = (ClientAvatar)e.Packet;
if (avatar.AvatarBytes.Length == 0)
{
Avatar = null;
}
else
{
Avatar = avatar.AvatarBytes;
OrgAvatar ??= avatar.AvatarBytes;
}
break;
case AresId.MSG_CHAT_CLIENT_CUSTOM_DATA: {
ClientCustom custom = (ClientCustom)e.Packet;
string username = string.IsNullOrEmpty(custom.Username) ? Name : custom.Username;
custom.Username = Name;
IClient target = server.FindUser((s) => s.Name == username);
if (target != null && !target.Ignored.Contains(Name))
{
server.SendPacket(target, custom);
}
}
break;
case AresId.MSG_CHAT_CLIENT_CUSTOM_DATA_ALL:
ClientCustomAll customAll = (ClientCustomAll)e.Packet;
server.SendPacket((s) =>
s != this &&
s.Vroom == Vroom &&
s.CanSee(this),
new ClientCustom(Name, customAll));
break;
}
}
/// <summary>
/// Packets handled in this function could possibly be overriden by a plugin
/// </summary>
internal void HandleOverridePacket(PacketEventArgs e)
{
switch ((AresId)e.Packet.Id)
{
case AresId.MSG_CHAT_CLIENT_PUBLIC:
ClientPublic pub = (ClientPublic)e.Packet;
if (!String.IsNullOrEmpty(pub.Message))
{
server.SendPacket((s) =>
s.Vroom == Vroom &&
!s.Ignored.Contains(Name),
new ServerPublic(Name, pub.Message));
}
break;
case AresId.MSG_CHAT_CLIENT_EMOTE:
ClientEmote emote = (ClientEmote)e.Packet;
if (!String.IsNullOrEmpty(emote.Message))
{
server.SendPacket((s) =>
s.Vroom == Vroom &&
!s.Ignored.Contains(Name),
new ServerEmote(Name, emote.Message));
}
break;
case AresId.MSG_CHAT_CLIENT_PVT: {
Private priv = (Private)e.Packet;
if (String.IsNullOrEmpty(priv.Message))
{
return;
}
IClient target = server.FindUser((s) => s.Name == priv.Username);
if (target != null)
{
if (target.Ignored.Contains(Name))
{
server.SendPacket(this, new IgnoringYou(priv.Username));
}
else
{
priv.Username = Name;
server.SendPacket(target, priv);
}
}
else
{
server.SendPacket(this, new Offline(priv.Username));
}
}
break;
case AresId.MSG_CHAT_CLIENT_COMMAND:
//Command cmd = (Command)e.Packet;
//Not necessary to handle this here anymore
break;
case AresId.MSG_CHAT_CLIENT_PERSONAL_MESSAGE:
ClientPersonal personal = (ClientPersonal)e.Packet;
Message = personal.Message;
break;
case AresId.MSG_CHAT_CLIENT_AVATAR:
ClientAvatar avatar = (ClientAvatar)e.Packet;
if (Avatar.Equals(avatar))
{
break;
}
if (avatar.AvatarBytes.Length == 0)
{
Avatar = AresAvatar.Null;
}
else
{
Avatar = new AresAvatar(avatar.AvatarBytes);
if (OrgAvatar == null)
{
OrgAvatar = new AresAvatar(avatar.AvatarBytes);
}
}
break;
case AresId.MSG_CHAT_CLIENT_CUSTOM_DATA: {
ClientCustom custom = (ClientCustom)e.Packet;
string username = custom.Username;
custom.Username = Name;
IClient target = server.FindUser((s) => s.Name == username);
if (target != null && !target.Ignored.Contains(Name))
{
server.SendPacket(target, custom);
}
}
break;
case AresId.MSG_CHAT_CLIENT_CUSTOM_DATA_ALL:
ClientCustomAll customAll = (ClientCustomAll)e.Packet;
server.SendPacket((s) =>
s != this &&
s.Vroom == Vroom,
new ClientCustom(Name, customAll));
break;
}
}
