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; }
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; }
// POST api/serviceprovidedpersami public ServicesProvidedPerSaMI Post(ServicesProvidedPerSaMI ServicesProvidedPerSaMI) { if (ServicesProvidedPerSaMI.GUID > 0) { ServicesProvidedPerSaMI.SyncStatus = 1; ServicesProvidedPerSaMI.ServiceProvidedPerSaMIID = ServicesProvidedPerSaMI.GUID; int rowResult = ServicesProvidedPerSaMIBO.UpdateServiceProvidedPerSaMI(ServicesProvidedPerSaMI); //Return Back to The Client return ServicesProvidedPerSaMI; } else { ServicesProvidedPerSaMI.SyncStatus = 1; int rowResult = ServicesProvidedPerSaMIBO.InsertServiceProvidedPerSaMI(ServicesProvidedPerSaMI); ServicesProvidedPerSaMI.ServiceProvidedPerSaMIID = rowResult; //Return Back to The Client return ServicesProvidedPerSaMI; } }
// GET api/serviceprovidedpersami public IEnumerable<ServicesProvidedPerSaMI> Get(int Organization) { List<ServicesProvidedPerSaMI> listServicesProvidedPerSaMI = new List<ServicesProvidedPerSaMI>(); 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 dvServicesProvidedPerSaMI = ServicesProvidedPerSaMIBO.GetServicesProvidedPerSaMIIDForSync(CreatedBy); foreach (DataRowView drvServicesProvidedPerSaMI in dvServicesProvidedPerSaMI) { ServicesProvidedPerSaMI ServicesProvidedPerSaMI = new ServicesProvidedPerSaMI(); listServicesProvidedPerSaMI.Add(ServicesProvidedPerSaMIBO.GetServicesProvidedPerSaMIID(Convert.ToInt32(drvServicesProvidedPerSaMI["ServiceProvidedPerSaMIID"]))); } } return listServicesProvidedPerSaMI; }
public static int UpdateServiceProvidedPerSaMI(ServicesProvidedPerSaMI objServicesProvidedPerSaMI) { return new ServicesProvidedPerSaMIDAO().UpdateServiceProvidedPerSaMI(objServicesProvidedPerSaMI); }
public static int InsertServiceProvidedPerSaMI(ServicesProvidedPerSaMI objServicesProvidedPerSaMI) { return new ServicesProvidedPerSaMIDAO().InsertServiceProvidedPerSaMI(objServicesProvidedPerSaMI); }
public static ServicesProvidedPerSaMI GetServicesProvidedPerSaMIID(int ServiceProvidedPerSaMIID) { ServicesProvidedPerSaMI objServicesProvidedPerSaMIID = new ServicesProvidedPerSaMI(); return (ServicesProvidedPerSaMI)(new ServicesProvidedPerSaMIDAO().FillDTO(objServicesProvidedPerSaMIID, "ServiceProvidedPerSaMIID=" + ServiceProvidedPerSaMIID)); }
public static int UpdateServiceProvided(ServicesProvidedPerSaMI objServicesProvidedPerSaMI, FollowUpPerServices objFollowServices, List<AdditionalFollowUpInfoPerServices> lstAdditionalFollowUpInfoPerServices) { return new ServicesProvidedPerSaMIDAO().UpdateServiceProvided(objServicesProvidedPerSaMI, objFollowServices, lstAdditionalFollowUpInfoPerServices); }
public int UpdateServiceProvidedPerSaMI(ServicesProvidedPerSaMI objServicesProvidedPerSaMI) { int rowsaffected = -1; BeginTransaction(); try { String[] UpdateProperties = new String[] { "VisitTimes", "ServiceProvidedID", "UpdatedBy", "UpdatedDate", "SyncStatus" }; rowsaffected = Update(objServicesProvidedPerSaMI, UpdateProperties); CommitTransaction(); } catch (Exception e) { RollBackTransaction(); rowsaffected = -1; } return rowsaffected; }
public int InsertServiceProvidedPerSaMI(ServicesProvidedPerSaMI objServicesProvidedPerSaMI) { objServicesProvidedPerSaMI.ServiceProvidedPerSaMIID = 1; BeginTransaction(); try { objServicesProvidedPerSaMI.ServiceProvidedPerSaMIID = Insert(objServicesProvidedPerSaMI); CommitTransaction(); } catch (Exception ex) { RollBackTransaction(); objServicesProvidedPerSaMI.ServiceProvidedPerSaMIID = -1; } return objServicesProvidedPerSaMI.ServiceProvidedPerSaMIID; }
ServicesProvidedPerSaMI MapServicesProvidedPerSaMIDTO() { ServicesProvidedPerSaMI objServicesProvidedPerSaMI = new ServicesProvidedPerSaMI(); objServicesProvidedPerSaMI.VisitTimes = txtVisitTimes.Text; objServicesProvidedPerSaMI.ServiceProvidedID = Convert.ToInt32(ddlServiceProvided.SelectedValue); objServicesProvidedPerSaMI.SaMIProfileID = Convert.ToInt32(Request.QueryString.Get("ID")); objServicesProvidedPerSaMI.SyncStatus = 0; return objServicesProvidedPerSaMI; }