//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; } }