public bool UpdateDocumentCategory(DocCategoryVM docCategoryVM)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
tblDocCategory docCategory = unitOfWork.TblDocCategoryRepository.GetByID(docCategoryVM.DocCategoryID);
docCategory.CategoryName = docCategoryVM.CategoryName;
docCategory.ModifiedDate = DateTime.Now;
docCategory.ModifiedBy = docCategoryVM.ModifiedBy;
unitOfWork.TblDocCategoryRepository.Update(docCategory);
unitOfWork.Save();
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
public int InsertDoctorDetails(EntityDocCategory entOpera)
{
try
{
tblDocCategory obj = new tblDocCategory()
{
OperaCatId = entOpera.OperaCatId,
DocId = entOpera.DocId
};
objData.tblDocCategories.InsertOnSubmit(obj);
objData.SubmitChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
public int Update(EntityDocCategory entOpera)
{
try
{
tblDocCategory test = (from tbl in objData.tblDocCategories
where tbl.IsDelete == false &&
tbl.DocAllocId == entOpera.DocAllocId
select tbl).FirstOrDefault();
test.DocAllocId = entOpera.DocAllocId;
test.DocId = entOpera.DocId;
test.OperaCatId = entOpera.OperaCatId;
objData.SubmitChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
public bool DeleteDocumentCategory(int docCategoryID)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
tblDocCategory docCategory = unitOfWork.TblDocCategoryRepository.GetByID(docCategoryID);
unitOfWork.TblDocCategoryRepository.Delete(docCategory);
unitOfWork.Save();
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
public bool IsRecordExists(int Doctor_Id)
{
bool flag1 = false;
try
{
tblDocCategory objOpera = (from tbl in objData.tblDocCategories
where tbl.DocId.Equals(Doctor_Id)
select tbl).FirstOrDefault();
if (objOpera != null)
{
flag1 = true;
}
else
{
flag1 = false;
}
}
catch (Exception ex)
{
throw ex;
}
return(flag1);
}
