public async Task <IActionResult> Edit(Email_ConfigView Email_Config)
{
ResponseHelper objHelper = new ResponseHelper();
if (!ModelState.IsValid)
{
objHelper.Status = StatusCodes.Status424FailedDependency;
objHelper.Message = ModelException.Errors(ModelState);
return(BadRequest(objHelper));
}
try
{
if (Email_ConRepo.Exists(Email_Config))
{
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Data already available";
return(Ok(objHelper));
}
await Email_ConRepo.Update(Email_Config);
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Saved Successfully";
return(Ok(objHelper));
}
catch (Exception ex)
{
objHelper.Status = StatusCodes.Status500InternalServerError;
objHelper.Message = ex.Message;
return(StatusCode(StatusCodes.Status500InternalServerError, objHelper));
}
}
public async Task Update(Email_ConfigView entity)
{
try
{
var vList = adbContext.email_config.Where(x => x.Email_Config_Id == entity.Email_Config_Id).FirstOrDefault();
if (vList == null)
{
throw new RecoredNotFoundException("Data Not Available");
}
vList.Company_Id = entity.Company_Id;
vList.Email_Host = entity.Email_Host;
vList.Email_Port = entity.Email_Port;
vList.Email_UserName = entity.Email_UserName;
vList.EnableSSL = entity.EnableSSL;
vList.isActive = entity.isActive;
vList.UpdatedBy = entity.UpdatedBy;
vList.UpdatedOn = DateTime.Now;
adbContext.email_config.Update(vList);
await Task.FromResult(adbContext.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> Add(Email_ConfigView Email_Config)
{
ResponseHelper objHelper = new ResponseHelper();
if (!ModelState.IsValid)
{
objHelper.Status = StatusCodes.Status424FailedDependency;
objHelper.Message = "Invalid Model State";
return(BadRequest(objHelper));
}
try
{
if (Email_ConRepo.Exists(Email_Config))
{
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Data already available";
return(Ok(objHelper));
}
await Email_ConRepo.Insert(Email_Config);
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Saved Successfully";
objHelper.Data = Email_Config;
return(Ok(objHelper));
}
catch
{
objHelper.Status = StatusCodes.Status500InternalServerError;
objHelper.Message = "Save Unsuccessful";
return(StatusCode(StatusCodes.Status500InternalServerError, objHelper));
}
}
public async Task Update(Email_ConfigView entity)
{
var vList = new Email_Config
{
Company_Id = entity.Company_Id,
Email_Host = entity.Email_Host,
Email_Port = entity.Email_Port,
Email_UserName = entity.Email_UserName,
EnableSSL = entity.EnableSSL,
isActive = entity.isActive,
UpdatedBy = entity.UpdatedBy,
UpdatedOn = DateTime.Now
};
adbContext.email_config.Update(vList);
await Task.FromResult(adbContext.SaveChanges());
}
public bool Exists(Email_ConfigView entity)
{
try
{
int intCount = 0;
if (entity.Email_Config_Id > 0) //Update Validation
{
intCount = adbContext.email_config.Where(w => w.Company_Id == entity.Company_Id && w.Email_Config_Id != entity.Email_Config_Id).Count();
}
else //Insert Validation
{
intCount = adbContext.email_config.Where(w => w.Company_Id == entity.Company_Id).Count();
}
return(intCount > 0 ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task Insert(Email_ConfigView entity)
{
try
{
//Insert New Email Config
var vList = new Email_Config
{
Company_Id = entity.Company_Id,
Email_Host = entity.Email_Host,
Email_Port = entity.Email_Port,
Email_UserName = entity.Email_UserName,
EnableSSL = entity.EnableSSL,
isActive = entity.isActive,
AddedBy = entity.AddedBy,
AddedOn = DateTime.Now
};
adbContext.email_config.Add(vList);
await Task.FromResult(adbContext.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
