public bool UpdateIntroducer(IntroducerVM introducerVM)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
//Update Introducer
tblIntroducer introducer = unitOfWork.TblIntroducerRepository.GetByID(introducerVM.IntroducerID);
introducer.IntroducerName = introducerVM.IntroducerName;
introducer.Description = introducerVM.Description;
introducer.Address1 = introducerVM.Address1;
introducer.Address2 = introducerVM.Address2;
introducer.Address3 = introducerVM.Address3;
introducer.ModifiedDate = DateTime.Now;
introducer.ModifiedBy = introducerVM.ModifiedBy;
unitOfWork.TblIntroducerRepository.Update(introducer);
unitOfWork.Save();
//Delete Existing Business Unit ID List
List <tblIntroducerBusinessUnit> existingBusinessUnitList = unitOfWork.TblIntroducerBusinessUnitRepository.Get(x => x.IntroducerID == introducerVM.IntroducerID).ToList();
foreach (tblIntroducerBusinessUnit existingBusinessUnit in existingBusinessUnitList)
{
unitOfWork.TblIntroducerBusinessUnitRepository.Delete(existingBusinessUnit);
unitOfWork.Save();
}
//Save New Business Unit ID List
foreach (int businessUnitID in introducerVM.BusinessUnitIDList)
{
tblIntroducerBusinessUnit introducerBusinessUnit = new tblIntroducerBusinessUnit();
introducerBusinessUnit.IntroducerID = introducer.IntroducerID;
introducerBusinessUnit.BUID = businessUnitID;
unitOfWork.TblIntroducerBusinessUnitRepository.Insert(introducerBusinessUnit);
unitOfWork.Save();
}
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
public IHttpActionResult UpdateIntroducer([FromBody] JObject data)
{
try
{
int introducerID = !string.IsNullOrEmpty(data.SelectToken("IntroducerID").Value <string>()) ? Convert.ToInt32(data.SelectToken("IntroducerID").Value <string>()) : 0;
string introducerName = !string.IsNullOrEmpty(data.SelectToken("IntroducerName").Value <string>()) ? data.SelectToken("IntroducerName").Value <string>() : string.Empty;
string description = !string.IsNullOrEmpty(data.SelectToken("Description").Value <string>()) ? data.SelectToken("Description").Value <string>() : string.Empty;
string address1 = !string.IsNullOrEmpty(data.SelectToken("Address1").Value <string>()) ? data.SelectToken("Address1").Value <string>() : string.Empty;
string address2 = !string.IsNullOrEmpty(data.SelectToken("Address2").Value <string>()) ? data.SelectToken("Address2").Value <string>() : string.Empty;
string address3 = !string.IsNullOrEmpty(data.SelectToken("Address3").Value <string>()) ? data.SelectToken("Address3").Value <string>() : string.Empty;
List <int> businessUnitIDList = data.SelectToken("BusinessUnitIDList").ToObject <List <int> >();
int userID = !string.IsNullOrEmpty(data.SelectToken("UserID").Value <string>()) ? Convert.ToInt32(data.SelectToken("UserID").Value <string>()) : 0;
if (!manageIntroducer.IsIntroducerAvailable(introducerID, introducerName))
{
IntroducerVM introducerVM = new IntroducerVM();
introducerVM.IntroducerID = introducerID;
introducerVM.IntroducerName = introducerName;
introducerVM.Description = description;
introducerVM.Address1 = address1;
introducerVM.Address2 = address2;
introducerVM.Address3 = address3;
introducerVM.BusinessUnitIDList = businessUnitIDList;
introducerVM.ModifiedBy = userID;
bool status = manageIntroducer.UpdateIntroducer(introducerVM);
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 = "Introducer Name already exists" }));
}
}
catch (Exception ex)
{
return(Json(new { status = false, message = "Unknown error occurred" }));
}
}
public List <IntroducerVM> GetAllIntroducersByBusinessUnitID(int businessUnitID)
{
try
{
//List<tblIntroducerBusinessUnit> introducerData = unitOfWork.TblIntroducerBusinessUnitRepository.Get(x => x.BUID == businessUnitID).ToList().GroupBy(x => x.IntroducerID).Select(x => x.FirstOrDefault()).ToList();
List <tblIntroducerBusinessUnit> introducerData = unitOfWork.TblIntroducerBusinessUnitRepository.Get().ToList();;
List <IntroducerVM> introducerList = new List <IntroducerVM>();
foreach (var introducer in introducerData)
{
IntroducerVM introducerVM = new IntroducerVM();
introducerVM.IntroducerID = introducer.tblIntroducer.IntroducerID;
introducerVM.IntroducerName = introducer.tblIntroducer.IntroducerName;
introducerVM.Description = introducer.tblIntroducer.Description;
introducerVM.Address1 = introducer.tblIntroducer.Address1;
introducerVM.Address2 = introducer.tblIntroducer.Address2;
introducerVM.Address3 = introducer.tblIntroducer.Address3;
introducerVM.CreatedDate = introducer.tblIntroducer.CreatedDate != null?introducer.tblIntroducer.CreatedDate.ToString() : string.Empty;
introducerVM.ModifiedDate = introducer.tblIntroducer.ModifiedDate != null?introducer.tblIntroducer.ModifiedDate.ToString() : string.Empty;
introducerVM.CreatedBy = introducer.tblIntroducer.CreatedBy != null?Convert.ToInt32(introducer.tblIntroducer.CreatedBy) : 0;
introducerVM.ModifiedBy = introducer.tblIntroducer.ModifiedBy != null?Convert.ToInt32(introducer.tblIntroducer.ModifiedBy) : 0;
List <int> businessUnitIDList = new List <int>();
List <tblIntroducerBusinessUnit> introducerBusinessUnitList = unitOfWork.TblIntroducerBusinessUnitRepository.Get(x => x.IntroducerID == introducer.tblIntroducer.IntroducerID).ToList();
foreach (tblIntroducerBusinessUnit introducerBusinessUnit in introducerBusinessUnitList)
{
businessUnitIDList.Add(introducerBusinessUnit.BUID);
}
introducerVM.BusinessUnitIDList = businessUnitIDList;
introducerList.Add(introducerVM);
}
return(introducerList);
}
catch (Exception ex)
{
throw;
}
}
public bool SaveIntroducer(IntroducerVM introducerVM)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
//Save Introducer
tblIntroducer introducer = new tblIntroducer();
introducer.IntroducerName = introducerVM.IntroducerName;
introducer.Description = introducerVM.Description;
introducer.Address1 = introducerVM.Address1;
introducer.Address2 = introducerVM.Address2;
introducer.Address3 = introducerVM.Address3;
introducer.CreatedDate = DateTime.Now;
introducer.CreatedBy = introducerVM.CreatedBy;
unitOfWork.TblIntroducerRepository.Insert(introducer);
unitOfWork.Save();
//Save Business Unit ID List
foreach (int businessUnitID in introducerVM.BusinessUnitIDList)
{
tblIntroducerBusinessUnit introducerBusinessUnit = new tblIntroducerBusinessUnit();
introducerBusinessUnit.IntroducerID = introducer.IntroducerID;
introducerBusinessUnit.BUID = businessUnitID;
unitOfWork.TblIntroducerBusinessUnitRepository.Insert(introducerBusinessUnit);
unitOfWork.Save();
}
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
public IntroducerVM GetIntroducerByID(int introducerID)
{
try
{
var introducerData = unitOfWork.TblIntroducerRepository.GetByID(introducerID);
IntroducerVM introducerVM = new IntroducerVM();
introducerVM.IntroducerID = introducerData.IntroducerID;
introducerVM.IntroducerName = introducerData.IntroducerName;
introducerVM.Description = introducerData.Description;
introducerVM.Address1 = introducerData.Address1;
introducerVM.Address2 = introducerData.Address2;
introducerVM.Address3 = introducerData.Address3;
introducerVM.CreatedDate = introducerData.CreatedDate != null?introducerData.CreatedDate.ToString() : string.Empty;
introducerVM.ModifiedDate = introducerData.ModifiedDate != null?introducerData.ModifiedDate.ToString() : string.Empty;
introducerVM.CreatedBy = introducerData.CreatedBy != null?Convert.ToInt32(introducerData.CreatedBy) : 0;
introducerVM.ModifiedBy = introducerData.ModifiedBy != null?Convert.ToInt32(introducerData.ModifiedBy) : 0;
List <int> businessUnitIDList = new List <int>();
List <tblIntroducerBusinessUnit> introducerBusinessUnitList = unitOfWork.TblIntroducerBusinessUnitRepository.Get(x => x.IntroducerID == introducerID).ToList();
foreach (tblIntroducerBusinessUnit introducerBusinessUnit in introducerBusinessUnitList)
{
businessUnitIDList.Add(introducerBusinessUnit.BUID);
}
introducerVM.BusinessUnitIDList = businessUnitIDList;
return(introducerVM);
}
catch (Exception ex)
{
throw;
}
}
