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)); }