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