public bool UpdateRequiredDocument(RequiredDocumentVM requiredDocumentVM)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
tblRequiredDocument requiredDocument = unitOfWork.TblRequiredDocumentRepository.GetByID(requiredDocumentVM.RequiredDocID);
requiredDocument.insClassID = requiredDocumentVM.InsuranceClassID;
requiredDocument.insSubClassID = requiredDocumentVM.InsuranceSubClassID;
requiredDocument.DocCategoryID = requiredDocumentVM.DocCategoryID;
requiredDocument.DocumentName = requiredDocumentVM.DocumentName;
requiredDocument.ModifiedDate = DateTime.Now;
requiredDocument.ModifiedBy = requiredDocumentVM.ModifiedBy;
unitOfWork.TblRequiredDocumentRepository.Update(requiredDocument);
unitOfWork.Save();
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
public List <RequiredDocumentVM> GetAllRequiredDocumentsByBusinessUnitID(int businessUnitID)
{
try
{
var requiredDocData = unitOfWork.TblRequiredDocumentRepository.Get(x => x.tblInsClass.BUID == businessUnitID).ToList();
List <RequiredDocumentVM> requiredDocList = new List <RequiredDocumentVM>();
foreach (var requiredDoc in requiredDocData)
{
RequiredDocumentVM requiredDocumentVM = new RequiredDocumentVM();
requiredDocumentVM.RequiredDocID = requiredDoc.ReqDocID;
requiredDocumentVM.InsuranceClassID = requiredDoc.insClassID != null?Convert.ToInt32(requiredDoc.insClassID) : 0;
if (requiredDocumentVM.InsuranceClassID > 0)
{
requiredDocumentVM.InsuranceClassName = requiredDoc.tblInsClass.Code;
}
requiredDocumentVM.InsuranceSubClassID = requiredDoc.insSubClassID != null?Convert.ToInt32(requiredDoc.insSubClassID) : 0;
if (requiredDocumentVM.InsuranceSubClassID > 0)
{
requiredDocumentVM.InsuranceSubClassName = requiredDoc.tblInsSubClass.Description;
}
requiredDocumentVM.DocCategoryID = requiredDoc.DocCategoryID != null?Convert.ToInt32(requiredDoc.DocCategoryID) : 0;
if (requiredDocumentVM.DocCategoryID > 0)
{
requiredDocumentVM.DocCategoryName = requiredDoc.tblDocCategory.CategoryName;
}
requiredDocumentVM.DocumentName = requiredDoc.DocumentName;
requiredDocumentVM.CreatedDate = requiredDoc.CreatedDate != null?requiredDoc.CreatedDate.ToString() : string.Empty;
requiredDocumentVM.ModifiedDate = requiredDoc.ModifiedDate != null?requiredDoc.ModifiedDate.ToString() : string.Empty;
requiredDocumentVM.CreatedBy = requiredDoc.CreatedBy != null?Convert.ToInt32(requiredDoc.CreatedBy) : 0;
requiredDocumentVM.ModifiedBy = requiredDoc.ModifiedBy != null?Convert.ToInt32(requiredDoc.ModifiedBy) : 0;
requiredDocList.Add(requiredDocumentVM);
}
return(requiredDocList);
}
catch (Exception ex)
{
throw;
}
}
public RequiredDocumentVM GetRequiredDocumentByID(int requiredDocID)
{
try
{
var requiredDocData = unitOfWork.TblRequiredDocumentRepository.GetByID(requiredDocID);
RequiredDocumentVM requiredDocumentVM = new RequiredDocumentVM();
requiredDocumentVM.RequiredDocID = requiredDocData.ReqDocID;
requiredDocumentVM.InsuranceClassID = requiredDocData.insClassID != null?Convert.ToInt32(requiredDocData.insClassID) : 0;
if (requiredDocumentVM.InsuranceClassID > 0)
{
requiredDocumentVM.InsuranceClassName = requiredDocData.tblInsClass.Code;
}
requiredDocumentVM.InsuranceSubClassID = requiredDocData.insSubClassID != null?Convert.ToInt32(requiredDocData.insSubClassID) : 0;
if (requiredDocumentVM.InsuranceSubClassID > 0)
{
requiredDocumentVM.InsuranceSubClassName = requiredDocData.tblInsSubClass.Description;
}
requiredDocumentVM.DocCategoryID = requiredDocData.DocCategoryID != null?Convert.ToInt32(requiredDocData.DocCategoryID) : 0;
if (requiredDocumentVM.DocCategoryID > 0)
{
requiredDocumentVM.DocCategoryName = requiredDocData.tblDocCategory.CategoryName;
}
requiredDocumentVM.DocumentName = requiredDocData.DocumentName;
requiredDocumentVM.CreatedDate = requiredDocData.CreatedDate != null?requiredDocData.CreatedDate.ToString() : string.Empty;
requiredDocumentVM.ModifiedDate = requiredDocData.ModifiedDate != null?requiredDocData.ModifiedDate.ToString() : string.Empty;
requiredDocumentVM.CreatedBy = requiredDocData.CreatedBy != null?Convert.ToInt32(requiredDocData.CreatedBy) : 0;
requiredDocumentVM.ModifiedBy = requiredDocData.ModifiedBy != null?Convert.ToInt32(requiredDocData.ModifiedBy) : 0;
return(requiredDocumentVM);
}
catch (Exception ex)
{
throw;
}
}
public IHttpActionResult UpdateRequiredDocument([FromBody] JObject data)
{
try
{
int requiredDocID = !string.IsNullOrEmpty(data.SelectToken("ReqDocID").Value <string>()) ? Convert.ToInt32(data.SelectToken("ReqDocID").Value <string>()) : 0;
int insClassID = !string.IsNullOrEmpty(data.SelectToken("insClassID").Value <string>()) ? Convert.ToInt32(data.SelectToken("insClassID").Value <string>()) : 0;
int insSubClassID = !string.IsNullOrEmpty(data.SelectToken("insSubClassID").Value <string>()) ? Convert.ToInt32(data.SelectToken("insSubClassID").Value <string>()) : 0;
int docCategoryID = !string.IsNullOrEmpty(data.SelectToken("DocCategoryID").Value <string>()) ? Convert.ToInt32(data.SelectToken("DocCategoryID").Value <string>()) : 0;
string documentName = !string.IsNullOrEmpty(data.SelectToken("DocumentName").Value <string>()) ? data.SelectToken("DocumentName").Value <string>() : string.Empty;
int userID = !string.IsNullOrEmpty(data.SelectToken("UserID").Value <string>()) ? Convert.ToInt32(data.SelectToken("UserID").Value <string>()) : 0;
if (!manageDocument.IsRequiredDocumentAvailable(requiredDocID, documentName))
{
RequiredDocumentVM requiredDocumentVM = new RequiredDocumentVM();
requiredDocumentVM.RequiredDocID = requiredDocID;
requiredDocumentVM.InsuranceClassID = insClassID;
requiredDocumentVM.InsuranceSubClassID = insSubClassID;
requiredDocumentVM.DocCategoryID = docCategoryID;
requiredDocumentVM.DocumentName = documentName;
requiredDocumentVM.ModifiedBy = userID;
bool status = manageDocument.UpdateRequiredDocument(requiredDocumentVM);
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 = "Required Document Name already exists" }));
}
}
catch (Exception ex)
{
return(Json(new { status = false, message = "Unknown error occurred" }));
}
}
