public bool ModelExsits(EquityBrokers model)
{
bool IsExsits = true;
if (_context.EquityBrokers.Where(e => e.Name == model.Name && e.NSEMembercode != model.NSEMembercode && e.MCXMembercode != model.MCXMembercode && e.BSEMembercode != model.BSEMembercode && e.ID != model.ID).FirstOrDefault() == null)
{
IsExsits = false;
}
else
{
IsExsits = true;
}
return(IsExsits);
}
//public JsonResponse UploadLogo(EquityBrokers modal)
//{
// try
// {
// if (modal != null)
// {
// var updateModal = _context.equityBrokers.Where(e => e.ID == modal.ID).FirstOrDefault();
// updateModal.Logo = modal.Logo;
// updateModal.ModifiedBy = 1;
// updateModal.ModifiedOn = DateTime.UtcNow;
// _context.Set<EquityBrokers>().Update(updateModal);
// if (_context.SaveChanges() > 0)
// {
// resp.Status = Constants.ResponseStatus.Success;
// resp.Message = "Record Updated Successfully";
// }
// else
// {
// resp.Status = "F";
// resp.Message = "Image not upload. please try again!";
// }
// }
// else
// {
// resp.Status = "F";
// resp.Message = "something went wrong !";
// }
// }
// catch (Exception ex)
// {
// }
// return resp;
//}
/// <summary>
/// Check Image in the database
/// </summary>
/// <param name="modal"></param>
/// <returns>Jsonresponse</returns>
public JsonResponse CheckImage(EquityBrokers model)
{
//Check the Image file name in the model and return the values if the condition true it retun the model logo name.
if (_context.EquityBrokers.Where(e => e.Logo == model.Logo).FirstOrDefault() != null)
{
resp.Status = Constants.ResponseStatus.Success;
resp.Data = model.Logo;
}
// Else the error function was trigger and send the message.
else
{
resp.Message = Constants.Service.Common_message;
}
return(resp);
}
/// <summary>
/// Add Update Data
/// </summary>
/// <param name="model"></param>
/// <returns>Jsonresponse</returns>
public JsonResponse AddUpdate(EquityBrokers model)
{
try
{
// If these condition true the data was not exsits in the database
if (!ModelExsits(model))
{
// If model.ID == 0 the data goes to the Add part.
if (model.ID == 0)
{
resp.Message = Constants.Service.Data_insert_failed;
model.CreatedOn = DateTime.Now;
model.CreatedBy = GetUserID();
_context.Set <EquityBrokers>().Add(model);
int i = _context.SaveChanges();
// If i != 0 means it affect one data So the data was Inserted.
if (i != 0)
{
resp.Status = Constants.ResponseStatus.Success;
resp.Message = Constants.Service.Data_insert_success;
}
//esle It gives some error in data insertion.
else
{
var file = Path.Combine(_HostingEnvironment.WebRootPath, "NewFolder", model.Logo);
if (File.Exists(file))
{
File.Delete(file);
}
}
}
// Else data goes to the Update part.
else
{
resp.Message = Constants.Service.Data_Update_failed;
var models = GetData(model.ID);
// If the models not null it get the database data belongs to the ID
if (models != null)
{
models.AddressLine1 = model.AddressLine1;
models.AddressLine2 = model.AddressLine2;
models.CountryID = model.CountryID;
models.StateID = model.StateID;
models.CityID = model.CityID;
models.PinCode = model.PinCode;
models.IsActive = model.IsActive;
models.ModifiedOn = DateTime.Now;
models.ModifiedBy = GetUserID();
_context.Set <EquityBrokers>().Update(models);
int i = _context.SaveChanges();
if (i != 0)
{
resp.Status = Constants.ResponseStatus.Success;
resp.Message = Constants.Service.Data_Update_success;
}
}
}
}
// The data was in the database so, It return the else part
else
{
resp.Message = Constants.ControllerMessage.Data_Exsists;
}
}
catch (Exception)
{
resp.Message = Constants.Service.Common_message;
}
return(resp);
}
