/// <summary>
/// Finds and return cEmpProfessionalDetail objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cEmpProfessionalDetail objects</returns>
public static List <cEmpProfessionalDetail> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cEmpProfessionalDetail> l = new List <cEmpProfessionalDetail>();
cEmpProfessionalDetail oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cEmpProfessionalDetail();
oObj.m_iID = Convert.ToInt32(dt.Rows[i]["iID"]);
oObj.m_sName = dt.Rows[i]["sName"].ToString();
oObj.m_dtCreatedOn = Convert.ToDateTime(dt.Rows[i]["dtCreatedOn"]);
oObj.m_dtLastUpdatedOn = Convert.ToDateTime(dt.Rows[i]["dtLastUpdatedOn"]);
oObj.m_sCompanyName = Convert.ToString(dt.Rows[i]["sCompanyName"]);
oObj.m_sDesignation = Convert.ToString(dt.Rows[i]["sDesignation"]);
oObj.m_sProfileDescription = Convert.ToString(dt.Rows[i]["sProfileDescription"]);
oObj.m_dtFromDate = Convert.ToDateTime(dt.Rows[i]["dtFromDate"]);
oObj.m_dtEndDate = Convert.ToDateTime(dt.Rows[i]["dtEndDate"]);
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_objEmpLogin.iObjectID = Convert.ToInt32(dt.Rows[i]["objEmpLogin"].ToString());
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Creates a cEmpProfessionalDetail object. It will be saved in permanent storage only
/// on calling Save()
/// </summary>
/// <returns>cEmpProfessionalDetail object</returns>
public static cEmpProfessionalDetail Create()
{
cEmpProfessionalDetail oObj = new cEmpProfessionalDetail();
SecurityCheck((int)enEmpProfessionalDetail_Action.Create);
// Create an object in memory, will be saved to storage on calling Save()
oObj.m_bCreating = true;
oObj.m_bInvalid = false;
return(oObj);
}
/// <summary>
/// Ensures that an object with the specified name exists, while creating other properties are set to their default values
/// </summary>
/// <param name="i_sName">Name</param>
/// <returns>cEmpProfessionalDetail object</returns>
public static cEmpProfessionalDetail CreateIfRequiredAndGet(string i_sName)
{
cEmpProfessionalDetail oObj = cEmpProfessionalDetail.Get_Name(i_sName);
if (oObj == null)
{
oObj = cEmpProfessionalDetail.Create();
oObj.sName = i_sName;
oObj.Save();
}
return(oObj);
}
public ActionResult EmpProfessional()
{
string Professional = Request.QueryString["Professional"];
List <EmpProfessionalDetails> list = Newtonsoft.Json.JsonConvert.DeserializeObject <List <EmpProfessionalDetails> >(Professional);
int LoginId = Convert.ToInt32(HttpContext.User.Identity.Name);
for (var i = 0; i < list.Count; i++)
{
cEmpProfessionalDetail objEudCreate = cEmpProfessionalDetail.Create();
objEudCreate.sCompanyName = list[i].CompanyName;
objEudCreate.sDesignation = list[i].Designation;
DateTime dt1 = list[i].FromDate;
DateTime dt2 = list[i].EndDate;
objEudCreate.dtFromDate = Convert.ToDateTime(dt1);
objEudCreate.dtEndDate = Convert.ToDateTime(dt2);
objEudCreate.objEmpLogin.iObjectID = LoginId;
objEudCreate.Save();
}
TempData["Prof"] = 1;
return(RedirectToAction("Profile"));
}
using System;
