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)); }