public bool UpdateTaxType(TaxTypeVM taxTypeVM) { using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction()) { try { tblTaxType taxType = unitOfWork.TblTaxTypeRepository.GetByID(taxTypeVM.TaxTypeID); taxType.TaxTypeCode = taxTypeVM.TaxTypeCode; taxType.Description = taxTypeVM.Description; taxType.Percentage = taxTypeVM.Percentage; taxType.ExpiryDate = !string.IsNullOrEmpty(taxTypeVM.ExpiryDate) ? DateTime.ParseExact(taxTypeVM.ExpiryDate, "MM/dd/yyyy", CultureInfo.InvariantCulture) : (DateTime?)null; taxType.IsActive = taxTypeVM.IsActive; taxType.ModifiedDate = DateTime.Now; taxType.ModifiedBy = taxTypeVM.ModifiedBy; unitOfWork.TblTaxTypeRepository.Update(taxType); unitOfWork.Save(); //Complete the Transaction dbTransaction.Commit(); return(true); } catch (Exception ex) { //Roll back the Transaction dbTransaction.Rollback(); return(false); } } }
public TaxTypeVM GetTaxTypeByID(int taxTypeID) { try { var taxTypeData = unitOfWork.TblTaxTypeRepository.GetByID(taxTypeID); TaxTypeVM taxTypeVM = new TaxTypeVM(); taxTypeVM.TaxTypeID = taxTypeData.TaxTypeID; taxTypeVM.TaxTypeCode = taxTypeData.TaxTypeCode; taxTypeVM.Description = taxTypeData.Description; taxTypeVM.Percentage = taxTypeData.Percentage != null?Convert.ToDouble(taxTypeData.Percentage) : 0; taxTypeVM.ExpiryDate = taxTypeData.ExpiryDate != null?taxTypeData.ExpiryDate.ToString() : string.Empty; taxTypeVM.IsActive = taxTypeData.IsActive; taxTypeVM.CreatedBy = taxTypeData.CreatedBy != null?Convert.ToInt32(taxTypeData.CreatedBy) : 0; taxTypeVM.CreatedDate = taxTypeData.CreatedDate != null?taxTypeData.CreatedDate.ToString() : string.Empty; taxTypeVM.ModifiedBy = taxTypeData.ModifiedBy != null?Convert.ToInt32(taxTypeData.ModifiedBy) : 0; taxTypeVM.ModifiedDate = taxTypeData.ModifiedDate != null?taxTypeData.ModifiedDate.ToString() : string.Empty; return(taxTypeVM); } catch (Exception ex) { throw; } }
public IHttpActionResult UpdateTaxType([FromBody] JObject data) { try { int taxTypeID = !string.IsNullOrEmpty(data.SelectToken("TaxTypeID").Value <string>()) ? Convert.ToInt32(data.SelectToken("TaxTypeID").Value <string>()) : 0; string taxTypeCode = !string.IsNullOrEmpty(data.SelectToken("TaxTypeCode").Value <string>()) ? data.SelectToken("TaxTypeCode").Value <string>() : string.Empty; string description = !string.IsNullOrEmpty(data.SelectToken("Description").Value <string>()) ? data.SelectToken("Description").Value <string>() : string.Empty; double percentage = !string.IsNullOrEmpty(data.SelectToken("Percentage").Value <string>()) ? Convert.ToDouble(data.SelectToken("Percentage").Value <string>()) : 0; string expiryDate = !string.IsNullOrEmpty(data.SelectToken("ExpiryDate").Value <string>()) ? data.SelectToken("ExpiryDate").Value <string>() : string.Empty; bool isActive = !string.IsNullOrEmpty(data.SelectToken("IsActive").Value <string>()) ? Convert.ToBoolean(data.SelectToken("IsActive").Value <string>()) : false; int userID = !string.IsNullOrEmpty(data.SelectToken("UserID").Value <string>()) ? Convert.ToInt32(data.SelectToken("UserID").Value <string>()) : 0; if (!manageTax.IsTaxTypeAvailable(taxTypeID, taxTypeCode)) { TaxTypeVM taxTypeVM = new TaxTypeVM(); taxTypeVM.TaxTypeID = taxTypeID; taxTypeVM.TaxTypeCode = taxTypeCode; taxTypeVM.Description = description; taxTypeVM.Percentage = percentage; taxTypeVM.ExpiryDate = expiryDate; taxTypeVM.IsActive = isActive; taxTypeVM.ModifiedBy = userID; bool status = manageTax.UpdateTaxType(taxTypeVM); if (status) { return(Json(new { status = true, message = "Successfully Updated" })); } else { return(Json(new { status = false, message = "Update Failed" })); } } else { return(Json(new { status = false, message = "Tax Type already exists" })); } } catch (Exception ex) { return(Json(new { status = false, message = "Unknown error occurred" })); } }
public List <TaxTypeVM> GetAllTaxTypes() { try { var taxTypeData = unitOfWork.TblTaxTypeRepository.Get().ToList(); List <TaxTypeVM> taxTypeList = new List <TaxTypeVM>(); foreach (var taxType in taxTypeData) { TaxTypeVM taxTypeVM = new TaxTypeVM(); taxTypeVM.TaxTypeID = taxType.TaxTypeID; taxTypeVM.TaxTypeCode = taxType.TaxTypeCode; taxTypeVM.Description = taxType.Description; taxTypeVM.Percentage = taxType.Percentage != null?Convert.ToDouble(taxType.Percentage) : 0; taxTypeVM.ExpiryDate = taxType.ExpiryDate != null?taxType.ExpiryDate.ToString() : string.Empty; taxTypeVM.IsActive = taxType.IsActive; taxTypeVM.CreatedBy = taxType.CreatedBy != null?Convert.ToInt32(taxType.CreatedBy) : 0; taxTypeVM.CreatedDate = taxType.CreatedDate != null?taxType.CreatedDate.ToString() : string.Empty; taxTypeVM.ModifiedBy = taxType.ModifiedBy != null?Convert.ToInt32(taxType.ModifiedBy) : 0; taxTypeVM.ModifiedDate = taxType.ModifiedDate != null?taxType.ModifiedDate.ToString() : string.Empty; taxTypeList.Add(taxTypeVM); } return(taxTypeList); } catch (Exception ex) { throw; } }