/// <summary>
/// Summary view of ClientMain Master
/// </summary>
/// <returns></returns>
// [TypeFilter(typeof(AuthorizeAction), Arguments = new object[] { "Read" })]
public IActionResult SummaryView()
{
ClientMainViewModel model = new ClientMainViewModel();
InitAccessModel(model);
return(View(model));
}
public async Task <IActionResult> Main(int?id, string SuccessMessage = null)
{
ClientMainViewModel clientVM;
if (id.HasValue)
{
var client = await _context.Clients.SingleOrDefaultAsync(m => m.Id == id);
if (client == null)
{
return(NotFound());
}
clientVM = client.MapTo <ClientMainViewModel>();
}
else
{
clientVM = new ClientMainViewModel();
}
clientVM.IdentityProtocolTypes = new List <string> {
ProtocolTypes.OpenIdConnect,
ProtocolTypes.Saml2p,
ProtocolTypes.WsFederation
};
return(View(clientVM));
}
/// <summary>
/// Add and Update view for the ClientMain master
/// </summary>
/// <returns></returns>
// [TypeFilter(typeof(AuthorizeAction), Arguments = new object[] { "Write" })]
public IActionResult Index()
{
ClientMainViewModel model = new ClientMainViewModel();
model.BankAccountTypeList = _interface.FillEnumList("BankAccountType");
model.AnnualIncomeList = _interface.FillEnumList("AnnualIncome");
model.CitizenShipList = _interface.FillEnumList("Citizenship");
model.MaterialList = _interface.FillEnumList("MaterialStatus");
model.ResidentalList = _interface.FillEnumList("ResidentialStatus");
model.TradingExperienceList = _interface.FillEnumList("TradingExperience");
model.EducationList = _interface.FillEnumList("Education");
model.GenderList = _interface.FillEnumList("Gender");
model.OccupationList = _interface.FillEnumList("OccupationType");
model.TitleList = _interface.FillEnumList("TitleType");
model.RelationShipList = _interface.FillEnumList("RelationShip");
model.ModelList = _interface.FillEnumList("ModelType");
model.ClientFamilyList = _interface.GetDropDownList(Constants.Procedures.ClienFamilyList);
model.EmployeeList = _interface.GetDropDownList(Constants.Procedures.EmployeeList);
model.BrokersList = _interface.GetDropDownList(Constants.Procedures.EquityBrokersList);
model.CountryList = _interface.GetDropDownList(Constants.Procedures.GetCountryDropDown);
model.MICRList = _interface.GetDropDownList(Constants.Procedures.MICRList);
model.DepositoryList = _interface.GetDropDownList(Constants.Procedures.DipositoriesList);
model.AccountTypeList = _interface.GetDropDownList(Constants.Procedures.GetAccountTypesDropDown);
model.SBUList = _interface.GetDropDownList(Constants.Procedures.SBUList);
model.BranchList = _interface.GetDropDownList(Constants.Procedures.EntityBranchList);
InitAccessModel(model);
return(View(model));
}
public IActionResult GetAccountsPartialView(int Flag)
{
ClientMainViewModel model = new ClientMainViewModel();
model.AccountTypeList = _interface.GetDropDownList(Constants.Procedures.GetAccountTypesDropDown);
model.Flag = Flag;
return(PartialView("_AccountsPartialView", model));
}
private void GetClient()
{
var user = new User()
{
Id = 1, Login = "******", Password = "******", Name = "Курлык", Phone = "33333"
};
//var uow = UnitOfWork.GetInstance();
//uow.Users.Insert(user);
//uow.SaveChanges();
CurrentPage = new ClientMainViewModel(user);
}
public IActionResult AddUpdate(ClientMainViewModel model)
{
JsonResponse resp = new JsonResponse();
// If the model valid go ti the next level
if (ModelState.IsValid)
{
return(Json(_interface.AddUpdate(model)));
} // Else it shows the error message.
else
{
resp.Message = Constants.ControllerMessage.All_Fields_Mandatory;
return(Json(resp));
}
}
public async Task <IActionResult> Main([FromBody] ClientMainViewModel clientVM)
{
var client = clientVM.MapTo <Client>();
if (clientVM.Id != 0)
{
_context.Update(client);
}
else
{
_context.Add(client);
}
await _context.SaveChangesAsync();
return(Ok(new { Id = client.Id }));
}
/// <summary>
/// Get the model value by ID and pass into the Update View
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
// [TypeFilter(typeof(AuthorizeAction), Arguments = new object[] { "Write" })]
public IActionResult Update(long ID)
{
ClientMainViewModel model = new ClientMainViewModel();
InitAccessModel(model);
model.ClientDetails = _interface.GetData(ID);
model.AddressDetails = _interface.GetAddressData(ID);
model.BankDetails = _interface.GetBankDetailsData(ID);
model.DepositryDetails = _interface.GetDepositryDetailData(ID);
model.EquityBrokerDetails = _interface.GetEquityBrokersData(ID);
model.PersonalDetails = _interface.GetPersonalDetailData(ID);
model.SecondaryContactDetails = _interface.GetSecondaryContactDetailData(ID);
model.MappingDetails = _interface.GetMappingDetailData(ID);
if (model.ClientDetails != null)
{
model.StateList = _interface.GetDropDownList(Constants.Procedures.FillStateDropDown);
model.AccountTypeList = _interface.GetDropDownList(Constants.Procedures.GetAccountTypesDropDown);
model.CityList = _interface.GetDropDownList(Constants.Procedures.FillCityDropDown);
model.BankAccountTypeList = _interface.FillEnumList("AccountType");
model.AnnualIncomeList = _interface.FillEnumList("AnnualIncome");
model.CitizenShipList = _interface.FillEnumList("Citizenship");
model.MaterialList = _interface.FillEnumList("MaterialStatus");
model.ResidentalList = _interface.FillEnumList("ResidentialStatus");
model.TradingExperienceList = _interface.FillEnumList("TradingExperience");
model.EducationList = _interface.FillEnumList("Education");
model.GenderList = _interface.FillEnumList("Gender");
model.OccupationList = _interface.FillEnumList("OccupationType");
model.TitleList = _interface.FillEnumList("TitleType");
model.RelationShipList = _interface.FillEnumList("RelationShip");
model.ModelList = _interface.FillEnumList("ModelType");
model.ClientFamilyList = _interface.GetDropDownList(Constants.Procedures.ClienFamilyList);
model.EmployeeList = _interface.GetDropDownList(Constants.Procedures.EmployeeList);
model.BrokersList = _interface.GetDropDownList(Constants.Procedures.EquityBrokersList);
model.CountryList = _interface.GetDropDownList(Constants.Procedures.GetCountryDropDown);
model.MICRList = _interface.GetDropDownList(Constants.Procedures.MICRList);
model.DepositoryList = _interface.GetDropDownList(Constants.Procedures.DipositoriesList);
model.SBUList = _interface.GetDropDownList(Constants.Procedures.SBUList);
model.BranchList = _interface.GetDropDownList(Constants.Procedures.EntityBranchList);
return(View("Index", model));
}
else
{
return(RedirectToAction("DateNotFound", "Home"));
}
}
//public ClientMainViewModel GetDatas(long ID)
//{
// //ClientMainViewModel model = new ClientMainViewModel
// {
// clientMain = GetData(ID),
// clientAddresses = GetAddressData(ID),
// clientBankDetails = GetBankDetailsData(ID),
// clientDepositry = GetDepositryDetailData(ID),
// clientEquityBrokerDetails = GetEquityBrokersData(ID),
// clientPersonalDetails = GetPersonalDetailData(ID),
// clientMappingDetails = GetMappingDetailData(ID),
// clientSecondaryContactDetails= GetSecondaryContactDetailData(ID)
// };
// return model;
//}
public JsonResponse AddUpdate(ClientMainViewModel model)
{
try
{
bool Valid_Mobile = IsExsits("Mobile", model.ClientDetails.MobileNumber.ToString()),
Valid_Email = IsExsits("Email", model.ClientDetails.EmailId),
Valid_Pan = IsExsits("PAN", model.ClientDetails.PAN);
if (!Valid_Mobile && !Valid_Pan && !Valid_Email)
{
long id;
SqlParameter[] param = new SqlParameter[16];
param[0] = new SqlParameter("@ID", model.ClientDetails.ID);
param[1] = new SqlParameter("@FamilyID", model.ClientDetails.FamilyID);
param[2] = new SqlParameter("@Title", model.ClientDetails.Title);
param[3] = new SqlParameter("@FirstName", model.ClientDetails.FirstName);
param[4] = new SqlParameter("@MiddleName", model.ClientDetails.MiddleName);
param[5] = new SqlParameter("@LastName", model.ClientDetails.LastName);
param[6] = new SqlParameter("@ShortName", model.ClientDetails.ShortName);
param[7] = new SqlParameter("@Gender", model.ClientDetails.Gender);
param[8] = new SqlParameter("@DOB", model.ClientDetails.DOB);
param[9] = new SqlParameter("@OccupationID", model.ClientDetails.OccupationID);
param[10] = new SqlParameter("@PAN", model.ClientDetails.PAN);
param[11] = new SqlParameter("@IntroducerID", model.ClientDetails.IntroducerID);
param[12] = new SqlParameter("@UserID", GetUserID());
//param[12] = new SqlParameter("@UserID", Convert.ToInt32(GetUserID("RoleID")));
param[13] = new SqlParameter("@IsActive", model.ClientDetails.IsActive);
param[14] = new SqlParameter("@Mobile", model.ClientDetails.MobileNumber);
param[15] = new SqlParameter("@EmailID", model.ClientDetails.EmailId);
id = Convert.ToInt64(new ADODataFunction().ExecuteScalar(Constants.Procedures.AddUpdateClientMain, param, CommandType.StoredProcedure));
// If i != 0 means it affect one data So the data was Inserted.
if (id != 0)
{
model.PersonalDetails.ClientID = id;
model.AddressDetails.ClientID = id;
model.SecondaryContactDetails.ClientID = id;
model.EquityBrokerDetails.ClientID = id;
model.DepositryDetails.ClientID = id;
model.BankDetails.ClientID = id;
model.MappingDetails.ClientID = id;
int i = AddUpdateClientPersonalDetails(model.PersonalDetails),
j = AddUpdateClientAddresses(model.AddressDetails),
k = AddUpdateClientSecondaryContactDetails(model.SecondaryContactDetails),
l = AddUpdateClientEquityBrokerDetails(model.EquityBrokerDetails),
m = AddUpdateClientDepositoryDetails(model.DepositryDetails),
n = AddUpdateClientBankDetails(model.BankDetails),
o = AddUpdateClientMappingDetails(model.MappingDetails);
if (i > 0 && j > 0 && k > 0 && l > 0 && m > 0 && n > 0 && o > 0)
{
if (model.ClientDetails.ID == 0)
{
resp.Message = Constants.Service.Data_insert_success;
}
else
{
resp.Message = Constants.Service.Data_Update_success;
}
resp.Status = Constants.ResponseStatus.Success;
resp.Data = id;
}
else
{
resp.Message = Constants.Service.Data_insert_failed;
}
}
//else It gives some error in data insertion.
else
{
resp.Message = Constants.Service.Data_insert_failed;
}
}
else
{
resp.Message = Constants.ControllerMessage.Data_Exsists;
}
}
catch (Exception ex)
{
resp.Message = Constants.Service.Common_message;
}
return(resp);
}
