public Int64 AddBasicDetail(InsurrerDetail detail)
{
try
{
using (IDbConnection db = new SqlConnection(ConnectionString))
{
string sql = "EXEC uspInsertBasicDetail @FirstName,@MiddleName,@LastName,@EmailID,@MobileNo,@State,@DateofBirth,@Gender,@AgentId,@CreatedBy,@CreatedDate,@ModifyDate,@PolicyStatus,@TempPolicyNo";
var returnId = db.ExecuteScalar <int>(sql, new
{
FirstName = detail.FirstName,
MiddleName = detail.MiddleName,
LastName = detail.LastName,
EmailID = detail.EmailID,
MobileNo = detail.MobileNo,
State = detail.State,
DateofBirth = detail.DateofBirth,
Gender = detail.Gender,
AgentId = detail.AgentId,
CreatedBy = detail.CreatedBy,
CreatedDate = DateTime.Now,
ModifyDate = DateTime.Now,
PolicyStatus = detail.PolicyStatus,
TempPolicyNo = detail.TempPolicyNo
});
return(returnId);
}
}
catch (Exception ex)
{
return(0);
}
}
public void AddBasicDetail()
{
var detail = new InsurrerDetail();
detail.FirstName = "Charles";
detail.MiddleName = detail.MiddleName == null ? "" : detail.MiddleName;
detail.LastName = "J";
detail.TempPolicyNo = 0;
detail.CreatedBy = 1;
detail.CreatedDate = DateTime.Now;
detail.ModifyDate = DateTime.Now;
detail.PolicyStatus = 1;
long result = repository.AddBasicDetail(detail);
}
public string CreateBasicDetail([FromBody] InsurrerDetail detail)
{
long result = 0;
try
{
detail.MiddleName = detail.MiddleName == null ? "" : detail.MiddleName;
detail.TempPolicyNo = 0;
detail.CreatedBy = detail.AgentId;
detail.CreatedDate = DateTime.Now;
detail.ModifyDate = DateTime.Now;
detail.PolicyStatus = 1;
result = repository.AddBasicDetail(detail);
}
catch (Exception dbEx)
{
return(Convert.ToString(result));
}
return(Convert.ToString(result));
}
