public async Task <string> SaveAgent(utblAgent model)
{
if (ModelState.IsValid)
{
string result = "";
string msg = objDal.SaveAgentAsync(model);
if (!(msg.Contains("Agent Details Updated")))
{
if (!(msg.Contains("Error")))
{
result = await Register(model.AgentEmail, model.AgentName, model.AgentMobile);
}
if (result != "User Registered")
{
await objDal.DeleteAgentAsync(Convert.ToInt64(msg));
}
}
else
{
result = msg;
}
return(result);
}
string messages = string.Join("; ", ModelState.Values
.SelectMany(x => x.Errors)
.Select(x => x.ErrorMessage));
return("Operation Error: " + messages);
}
public string SaveAgentAsync(utblAgent model)
{
try
{
var parPID = new SqlParameter("@AgentID", model.AgentID);
var parAName = new SqlParameter("@AgentName", model.AgentName);
var parAAddress = new SqlParameter("@AgentAddress", model.AgentAddress);
var parAEmail = new SqlParameter("@AgentEmail", model.AgentEmail);
var parAMobile = new SqlParameter("@AgentMobile", DBNull.Value);
if (model.AgentMobile != null)
{
parAMobile = new SqlParameter("@AgentMobile", model.AgentMobile);
}
var parADoc = new SqlParameter("@AgentDocumentPath", DBNull.Value);
if (model.AgentDocumentPath != null)
{
parADoc = new SqlParameter("@AgentDocumentPath", model.AgentDocumentPath);
}
var parAStatus = new SqlParameter("@Status", model.Status);
return(objDB.Database.SqlQuery <string>("udspAgentAddEdit @AgentID, @AgentName,@AgentAddress,@AgentEmail,@AgentMobile,@AgentDocumentPath,@Status",
parPID, parAName, parAAddress, parAEmail, parAMobile, parADoc, parAStatus).FirstOrDefault());
}
catch (Exception ex)
{
return("Error: " + ex.Message);
}
}
public async Task <utblAgent> GetAgentByIDAsync(long id)
{
utblAgent obj = new utblAgent();
obj = await objDB.utblAgents.Where(x => x.AgentID == id).FirstOrDefaultAsync();
return(obj);
}
