public int UpdateServiceProvided(ServicesProvidedPerSaMI objServicesProvidedPerSaMI, FollowUpPerServices objFollowServices, List<AdditionalFollowUpInfoPerServices> lstAdditionalFollowUpInfoPerServices)
{
int rowsaffected = -1;
BeginTransaction();
try
{
String[] UpdateProperties = new String[] { "VisitTimes", "ServiceProvidedID", "UpdatedBy", "UpdatedDate",
"SyncStatus"};
rowsaffected = Update(objServicesProvidedPerSaMI, UpdateProperties);
UpdateProperties = new String[] { "ICFollowUpRequired", "FollowUpID", "ICRecommendationID",
"CounselorDifficultyID", "UpdatedBy", "UpdatedDate",
"SyncStatus"};
rowsaffected = Update(objFollowServices, UpdateProperties);
Delete("tbl_additional_followup_info_per_service", "ServiceProvidedPerSaMIID = " + objServicesProvidedPerSaMI.ServiceProvidedPerSaMIID);
foreach (AdditionalFollowUpInfoPerServices objAdditionalFollowUpInfoPerServices in lstAdditionalFollowUpInfoPerServices)
{
objAdditionalFollowUpInfoPerServices.ServiceProvidedPerSaMIID = objServicesProvidedPerSaMI.ServiceProvidedPerSaMIID;
objAdditionalFollowUpInfoPerServices.SyncStatus = 0;
Insert(objAdditionalFollowUpInfoPerServices);
}
CommitTransaction();
}
catch (Exception e)
{
RollBackTransaction();
rowsaffected = -1;
}
return rowsaffected;
}
public int InsertServiceProvided(ServicesProvidedPerSaMI objServicesProvidedPerSaMI, FollowUpPerServices objFollowServices, List<AdditionalFollowUpInfoPerServices> lstAdditionalFollowUpInfoPerServices)
{
objServicesProvidedPerSaMI.ServiceProvidedPerSaMIID = 1;
BeginTransaction();
try
{
objServicesProvidedPerSaMI.ServiceProvidedPerSaMIID = Insert(objServicesProvidedPerSaMI);
objFollowServices.ServiceProvidedPerSaMIID = objServicesProvidedPerSaMI.ServiceProvidedPerSaMIID;
Insert(objFollowServices);
foreach (AdditionalFollowUpInfoPerServices objAdditionalFollowUpInfoPerServices in lstAdditionalFollowUpInfoPerServices)
{
objAdditionalFollowUpInfoPerServices.ServiceProvidedPerSaMIID = objServicesProvidedPerSaMI.ServiceProvidedPerSaMIID;
Insert(objAdditionalFollowUpInfoPerServices);
}
CommitTransaction();
}
catch (Exception ex)
{
RollBackTransaction();
objServicesProvidedPerSaMI.ServiceProvidedPerSaMIID = -1;
}
return objServicesProvidedPerSaMI.ServiceProvidedPerSaMIID;
}
// POST api/followupperservices
public FollowUpPerServices Post(FollowUpPerServices FollowUpPerServices)
{
if (FollowUpPerServices.GUID > 0)
{
FollowUpPerServices.SyncStatus = 1;
FollowUpPerServices.FollowUpPerServiceID = FollowUpPerServices.GUID;
int rowResult = FollowUpPerServicesBO.UpdateInsertFollowUpPerServices(FollowUpPerServices);
//Return Back to The Client
return FollowUpPerServices;
}
else
{
FollowUpPerServices.SyncStatus = 1;
int rowResult = FollowUpPerServicesBO.InsertFollowUpPerServices(FollowUpPerServices);
FollowUpPerServices.FollowUpPerServiceID = rowResult;
//Return Back to The Client
return FollowUpPerServices;
}
}
// GET api/followupperservices
public IEnumerable<FollowUpPerServices> Get(int Organization)
{
List<FollowUpPerServices> listFollowUpPerServices = new List<FollowUpPerServices>();
DataView dvUsers = UserBO.GetUsersIDByOrganization(Organization);
string TempCreatedBy = "";
if (dvUsers.Count > 0)
{
foreach (DataRowView drvUsers in dvUsers)
{
TempCreatedBy += "CreatedBy=" + drvUsers["UserID"] + " OR ";
}
string CreatedBy = TempCreatedBy.Remove(TempCreatedBy.Length - 3);
DataView dvFollowUpPerServices = FollowUpPerServicesBO.GetFollowUpPerServicesIDForSync(CreatedBy);
foreach (DataRowView drvFollowUpPerServices in dvFollowUpPerServices)
{
FollowUpPerServices FollowUpPerServices = new FollowUpPerServices();
listFollowUpPerServices.Add(FollowUpPerServicesBO.GetFollowUpPerServices(Convert.ToInt32(drvFollowUpPerServices["FollowUpPerServiceID"])));
}
}
return listFollowUpPerServices;
}
public static int UpdateServiceProvided(ServicesProvidedPerSaMI objServicesProvidedPerSaMI, FollowUpPerServices objFollowServices, List<AdditionalFollowUpInfoPerServices> lstAdditionalFollowUpInfoPerServices)
{
return new ServicesProvidedPerSaMIDAO().UpdateServiceProvided(objServicesProvidedPerSaMI, objFollowServices, lstAdditionalFollowUpInfoPerServices);
}
FollowUpPerServices MapFollowUpPerServicesDTO()
{
FollowUpPerServices objFollowUpPerServices = new FollowUpPerServices();
string ICRecommendation = string.Empty;
for (int j = 0; j < cblICRecommendation.Items.Count; j++)
{
if (cblICRecommendation.Items[j].Selected == true)
{
if (j == 0)
ICRecommendation = cblICRecommendation.Items[j].Value;
else
ICRecommendation = ICRecommendation + "," + cblICRecommendation.Items[j].Value;
}
}
objFollowUpPerServices.ICRecommendationID = ICRecommendation;
if (rdYes.Checked)
{
objFollowUpPerServices.ICFollowUpRequired = 1;
objFollowUpPerServices.FollowUpID = txtFollowUp.Text;
}
else
objFollowUpPerServices.ICFollowUpRequired = 0;
if (rbFurtherFollowUpYes.Checked)
{
objFollowUpPerServices.FurtherFollowUpRequired = 1;
objFollowUpPerServices.FurtherFollowUpID = Convert.ToInt32(ddlFurtherFollowUp.SelectedValue);
ddlFurtherFollowUp.Enabled = true;
}
else
objFollowUpPerServices.FurtherFollowUpRequired = 0;
objFollowUpPerServices.SyncStatus = 0;
return objFollowUpPerServices;
}
public static int UpdateInsertFollowUpPerServices(FollowUpPerServices objFollowServices)
{
return new FollowUpPerServicesDAO().UpdateInsertFollowUpPerServices(objFollowServices);
}
public static FollowUpPerServices GetFollowUpPerServices(int FollowUpPerServiceID)
{
FollowUpPerServices objFollowUpPerServicesID = new FollowUpPerServices();
return (FollowUpPerServices)(new FollowUpPerServicesDAO().FillDTO(objFollowUpPerServicesID, "FollowUpPerServiceID=" + FollowUpPerServiceID));
}
public static FollowUpPerServices GetFollowUpPerService(int ServiceProvidedPerSaMIID)
{
FollowUpPerServices objFollowUpPerServicesID = new FollowUpPerServices();
return (FollowUpPerServices)(new FollowUpPerServicesDAO().FillDTO(objFollowUpPerServicesID, "ServiceProvidedPerSaMIID=" + ServiceProvidedPerSaMIID));
}
