public ResponseModel CreateClaimCategory([FromBody] ClaimCategory claimCategory)
{
MasterCaller newMasterCaller = new MasterCaller();
ResponseModel objResponseModel = new ResponseModel();
int statusCode = 0;
string statusMessage = "";
try
{
string token = Convert.ToString(Request.Headers["X-Authorized-Token"]);
Authenticate authenticate = new Authenticate();
authenticate = SecurityService.GetAuthenticateDataFromTokenCache(Cache, SecurityService.DecryptStringAES(token));
claimCategory.CreatedBy = authenticate.UserMasterID;
claimCategory.TenantID = authenticate.TenantId;
int result = newMasterCaller.CreateClaimCategory(new CategoryServices(Cache, Db), claimCategory);
statusCode = result == 0 ? (int)EnumMaster.StatusCode.RecordNotFound : (int)EnumMaster.StatusCode.Success;
statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode);
objResponseModel.Status = true;
objResponseModel.StatusCode = statusCode;
objResponseModel.Message = statusMessage;
objResponseModel.ResponseData = result;
}
catch (Exception)
{
throw;
}
return(objResponseModel);
}
/// <summary>
/// Create Claim Category
/// </summary>
/// <param name="claimCategory"></param>
/// <returns></returns>
public int CreateClaimCategory(ClaimCategory claimCategory)
{
int result = 0;
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SP_CreateDepartment", conn);
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@BrandID", claimCategory.BrandName);
cmd.Parameters.AddWithValue("@StoreID", claimCategory.ClaimCategoryName);
cmd.Parameters.AddWithValue("@DepartmentID", claimCategory.ClaimSubCategory);
cmd.Parameters.AddWithValue("@FunctionID", claimCategory.ClaimIssueType);
cmd.Parameters.AddWithValue("@Status", claimCategory.Status);
cmd.Parameters.AddWithValue("@User_ID", claimCategory.CreatedBy);
cmd.Parameters.AddWithValue("@Tenant_ID", claimCategory.TenantID);
cmd.CommandType = CommandType.StoredProcedure;
result = Convert.ToInt32(cmd.ExecuteNonQuery());
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(result);
}
public static void Initialize(ApplicationDbContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Claims.Any())
{
return; // DB has been seeded
}
var currencies = new Currency[]
{
new Currency {
Name = "Korean Won", Symbol = "KRW"
},
new Currency {
Name = "Canadian Dollar", Symbol = "CAD"
},
new Currency {
Name = "US Dollar", Symbol = "USD"
},
};
foreach (Currency c in currencies)
{
context.Currencies.Add(c);
}
context.SaveChanges();
var categories = new ClaimCategory[]
{
new ClaimCategory {
Code = "AAA", Name = "Type A"
},
new ClaimCategory {
Code = "BBB", Name = "Type B"
},
new ClaimCategory {
Code = "CCC", Name = "Type C"
},
};
foreach (ClaimCategory c in categories)
{
context.ClaimCategories.Add(c);
}
context.SaveChanges();
var claims = new Claim[]
{
new Claim
{
Title = "test claim title 1",
RequesterId = "c2f9ac6d-0910-46c5-ae15-cda29f3eb8f4",
ApproverId = "4cf0b8b2-c883-44ac-a52f-1fca2abdba8a",
SubmitDate = new DateTime(2021, 01, 24),
RequesterComments = "Test Comment 1",
},
new Claim
{
Title = "test claim title 2",
RequesterId = "c2f9ac6d-0910-46c5-ae15-cda29f3eb8f4",
ApproverId = "4cf0b8b2-c883-44ac-a52f-1fca2abdba8a",
SubmitDate = new DateTime(2021, 01, 20),
RequesterComments = "Test Comment 2"
}
};
foreach (Claim c in claims)
{
context.Claims.Add(c);
}
context.SaveChanges();
var ClaimItems = new List <ClaimItem>
{
new ClaimItem {
ClaimId = 1, ClaimCategoryId = 1, CurrencyId = 2, Amount = 10.99M, Date = new DateTime(2021, 01, 03), Description = "This is a test item", Image = "https://static.nike.com/a/images/w_1536,c_limit/9de44154-c8c3-4f77-b47e-d992b7b96379/image.jpg", Payee = "MazcoMac"
},
new ClaimItem {
ClaimId = 1, ClaimCategoryId = 2, CurrencyId = 2, Amount = 110.99M, Date = new DateTime(2021, 01, 04), Description = "This is another test item", Image = "https://media.glamour.com/photos/5d4d8173a8093800088d56f8/16:9/w_3440,h_1935,c_limit/Jackets%20Everyone%20Should%20Own%20River.jpg", Payee = "Jason Huang",
},
new ClaimItem {
ClaimId = 1, ClaimCategoryId = 3, CurrencyId = 2, Amount = 210.99M, Date = new DateTime(2021, 01, 05), Description = "This is a still yet another test item", Image = "https://images2.minutemediacdn.com/image/upload/c_crop,h_1126,w_2000,x_0,y_181/f_auto,q_auto,w_1100/v1554932288/shape/mentalfloss/12531-istock-637790866.jpg", Payee = "Carson Xu"
},
new ClaimItem {
ClaimId = 2, ClaimCategoryId = 1, CurrencyId = 2, Amount = 12.99M, Date = new DateTime(2021, 01, 02), Description = "This is a test item", Image = "https://static.toiimg.com/photo/msid-67586673/67586673.jpg?3918697", Payee = "MazcoMac"
},
new ClaimItem {
ClaimId = 2, ClaimCategoryId = 2, CurrencyId = 2, Amount = 50.99M, Date = new DateTime(2021, 01, 05), Description = "This is another test item", Image = "https://c.files.bbci.co.uk/EB24/production/_112669106_66030514-b1c2-4533-9230-272b8368e25f.jpg", Payee = "Jason Huang",
},
new ClaimItem {
ClaimId = 2, ClaimCategoryId = 3, CurrencyId = 2, Amount = 310.99M, Date = new DateTime(2021, 01, 07), Description = "This is a still yet another test item", Image = "https://cdn.mos.cms.futurecdn.net/CxLvbQNp2Y4BQkTkpW5m7b.jpg", Payee = "Carson Xu"
},
};
foreach (ClaimItem ci in ClaimItems)
{
context.ClaimItems.Add(ci);
}
context.SaveChanges();
}
public int CreateClaimCategory(ICategory _category, ClaimCategory claimCategory)
{
_categoryList = _category;
return(_categoryList.CreateClaimCategory(claimCategory));
}
