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