public int DeletePreviousFEExperience(PreviousFEExperiences objPreviousFEExperience) { int rowsaffected = -1; BeginTransaction(); try { String[] UpdateProperties = new String[] { "Status" }; rowsaffected = Update(objPreviousFEExperience, UpdateProperties); CommitTransaction(); } catch (Exception e) { RollBackTransaction(); rowsaffected = -1; } return rowsaffected; }
public int InsertFEExperience(PreviousFEExperiences objPreviousFEExperiences) { objPreviousFEExperiences.ForeignEmploymentExperienceID = 1; BeginTransaction(); try { objPreviousFEExperiences.ForeignEmploymentExperienceID = Insert(objPreviousFEExperiences); CommitTransaction(); } catch (Exception ex) { RollBackTransaction(); objPreviousFEExperiences.ForeignEmploymentExperienceID = -1; } return objPreviousFEExperiences.ForeignEmploymentExperienceID; }
public int UpdateFEExperience(PreviousFEExperiences objPreviousFEExperiences) { int rowsaffected = -1; BeginTransaction(); try { String[] UpdateProperties = new String[] { "ForeignEmploymentExperienceID", "CountryID", "VisitFrequencyID", "DestinationAirportID", "JobOfferedType", "StayDuration", "UpdatedBy", "UpdatedDate", "Status", "SyncStatus" }; rowsaffected = Update(objPreviousFEExperiences, UpdateProperties); CommitTransaction(); } catch (Exception e) { RollBackTransaction(); rowsaffected = -1; } return rowsaffected; }
// POST api/previousfeexperiences public PreviousFEExperiences Post(PreviousFEExperiences PreviousFEExperiences) { if (PreviousFEExperiences.GUID > 0) { PreviousFEExperiences.SyncStatus = 1; PreviousFEExperiences.ForeignEmploymentExperienceID = PreviousFEExperiences.GUID; int rowResult = PreviousFEExperienceBO.UpdateFEExperience(PreviousFEExperiences); //Return Back to The Client return PreviousFEExperiences; } else { PreviousFEExperiences.SyncStatus = 1; int rowResult = PreviousFEExperienceBO.InsertFEExperience(PreviousFEExperiences); PreviousFEExperiences.ForeignEmploymentExperienceID = rowResult; //Return Back to The Client return PreviousFEExperiences; } }
// GET api/previousfeexperiences public IEnumerable<PreviousFEExperiences> Get(int Organization) { List<PreviousFEExperiences> listPreviousFEExperiences = new List<PreviousFEExperiences>(); DataView dvUsers = UserBO.GetUsersIDByOrganization(Organization);//PUT The Organization As Dynamic string TempCreatedBy = ""; if (dvUsers.Count > 0) { foreach (DataRowView drvUsers in dvUsers) { TempCreatedBy += "CreatedBy=" + drvUsers["UserID"] + " OR "; } string CreatedBy = TempCreatedBy.Remove(TempCreatedBy.Length - 3); DataView dvlistPreviousFEExperiences = PreviousFEExperienceBO.GetPreviousFEExperienceIDForSync(CreatedBy); foreach (DataRowView drvPreviousFEExperiences in dvlistPreviousFEExperiences) { PreviousFEExperiences PreviousFEExperiences = new PreviousFEExperiences(); listPreviousFEExperiences.Add(PreviousFEExperienceBO.GetFEExperience(Convert.ToInt32(drvPreviousFEExperiences["ForeignEmploymentExperienceID"]))); } } return listPreviousFEExperiences; }
public static PreviousFEExperiences GetByID(int PreviousFEID) { PreviousFEExperiences objPreviousFEExperiences = new PreviousFEExperiences(); return (PreviousFEExperiences)(new PreviousFEExperienceDAO().FillDTO(objPreviousFEExperiences, "ForeignEmploymentExperienceID=" + PreviousFEID)); }
public static PreviousFEExperiences GetPreviousFEExperiences(int SaMIProfileID) { PreviousFEExperiences objPreviousFEExperiences = new PreviousFEExperiences(); return (PreviousFEExperiences)(new PreviousFEExperienceDAO().FillDTO(objPreviousFEExperiences, "SaMIProfileID=" + SaMIProfileID)); }
public static int DeletePreviousFEExperience(PreviousFEExperiences objPreviousFEExperience) { return new PreviousFEExperienceDAO().DeletePreviousFEExperience(objPreviousFEExperience); }
public static int UpdateFEExperience(PreviousFEExperiences objPreviousFEExperiences) { objPreviousFEExperiences.UpdatedDate = DateTime.Now; return new PreviousFEExperienceDAO().UpdateFEExperience(objPreviousFEExperiences); }
public static int InsertFEExperience(PreviousFEExperiences objPreviousFEExperiences) { objPreviousFEExperiences.CreatedDate = DateTime.Now; return new PreviousFEExperienceDAO().InsertFEExperience(objPreviousFEExperiences); }
protected void gvPFE_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("cmdEdit")) { hfForeignEmploymentExperienceID.Value = e.CommandArgument.ToString(); lblPreviousID.Text = e.CommandArgument.ToString(); PreviousFEExperiences objPreviousFEExperience = PreviousFEExperienceBO.GetByID(Convert.ToInt32(e.CommandArgument.ToString())); ddlCountry.SelectedValue = objPreviousFEExperience.CountryID.ToString(); ddlStayDuration.SelectedValue = objPreviousFEExperience.StayDuration; ddlJobType.SelectedValue = objPreviousFEExperience.JobOfferedType.ToString(); } else if (e.CommandName.Equals("cmdDelete")) { hfForeignEmploymentExperienceID.Value = e.CommandArgument.ToString(); PreviousFEExperiences objPreviousFEExperience = new PreviousFEExperiences(); objPreviousFEExperience.ForeignEmploymentExperienceID = Convert.ToInt32(e.CommandArgument.ToString()); objPreviousFEExperience.Status = 0; objPreviousFEExperience.SyncStatus = 0; PreviousFEExperienceBO.DeletePreviousFEExperience(objPreviousFEExperience); LoadPreviousFEExperience(Convert.ToInt32(hfSaMIProfileID.Value)); LoadValidRegions(Convert.ToInt32(ddlEthnicity.SelectedValue)); } }
PreviousFEExperiences MapPreviousFEExperiencesDTO() { PreviousFEExperiences objPreviousFEExperiences = null; objPreviousFEExperiences = new PreviousFEExperiences(); objPreviousFEExperiences.SaMIProfileID = Convert.ToInt32(Request.QueryString.Get("ID")); objPreviousFEExperiences.UpdatedBy = UserAuthentication.GetUserId(this.Page); objPreviousFEExperiences.SyncStatus = 0; return objPreviousFEExperiences; }
PreviousFEExperiences MapPreviousFEExperiencesDTO() { PreviousFEExperiences objPreviousFEExperiences = null; objPreviousFEExperiences = new PreviousFEExperiences(); objPreviousFEExperiences.CountryID = Convert.ToInt32(ddlCountry.SelectedValue); objPreviousFEExperiences.JobOfferedType = Convert.ToInt32(ddlJobType.SelectedValue); objPreviousFEExperiences.StayDuration = ddlStayDuration.Text; objPreviousFEExperiences.SyncStatus = 0; return objPreviousFEExperiences; }