public async Task <string> CreateSmsTemplate(SmsTemplateDTO obj)
{
string status = "";
try
{
var checkexist = await _context.TSmstemplate
.AnyAsync(x => x.Name == obj.name || x.Code == obj.code);
if (checkexist == false)
{
TSmstemplate newrecord = new TSmstemplate
{
Name = obj.name,
Sender = obj.sender,
Message = obj.message,
Code = obj.code,
CreatedBy = _authUser.Name,
CreatedDate = DateTime.Now,
IsActive = true,
LastModified = null,
ModifiedBy = null
};
_context.TSmstemplate.Add(newrecord);
if (await _context.SaveChangesAsync() > 0)
{
status = "1";
return(status);
}
else
{
status = ResponseErrorMessageUtility.RecordNotSaved;
return(status);
}
}
status = string.Format(ResponseErrorMessageUtility.RecordExistBefore, obj.name);
return(status);
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
status = ResponseErrorMessageUtility.RecordNotSaved;
return(status);
}
}
public async Task <string> UpdateSmsTemplate(SmsTemplateDTO obj, int id)
{
string status = "";
try
{
//Check if record exist not as same id
var checkexist = await _context.TSmstemplate
.AnyAsync(x => x.SmstemplateId != id &&
(x.Name == obj.name || x.Code == obj.code));
if (checkexist == false)
{
var state = await _context.TSmstemplate
.FirstOrDefaultAsync(x => x.SmstemplateId == id);
state.Name = obj.name;
state.Sender = obj.sender;
state.Message = obj.message;
state.Code = obj.code;
state.SmstemplateId = id;
state.ModifiedBy = _authUser.Name;
state.LastModified = DateTime.Now;
if (await _context.SaveChangesAsync() > 0)
{
status = "1";
return(status);
}
else
{
status = ResponseErrorMessageUtility.RecordNotSaved;
return(status);
}
}
status = string.Format(ResponseErrorMessageUtility.RecordExistBefore, obj.name);
return(status);
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
status = ResponseErrorMessageUtility.RecordNotSaved;
return(status);
}
}
