public static BOEmployee FillData(BOEmployee itemObj, DataRow dr)
{
if (dr["EmployeeDetailsID"] != DBNull.Value)
itemObj.EmployeeDetailsID = Int32.Parse(dr["EmployeeDetailsID"].ToString());
if (dr["EmpProfileImage"] != DBNull.Value)
itemObj.EmpProfileImage = dr["EmpProfileImage"].ToString();
if (dr["EmployeeID"] != DBNull.Value)
itemObj.EmployeeID = Int32.Parse(dr["EmployeeID"].ToString());
if (dr["gender"] != DBNull.Value)
itemObj.gender = dr["gender"].ToString();
if (dr["MaritalStatus"] != DBNull.Value)
itemObj.MaritalStatus = dr["MaritalStatus"].ToString();
if (dr["DateOfBirth"] != DBNull.Value)
itemObj.DateOfBirth = DateTime.Parse(dr["DateOfBirth"].ToString());
if (dr["DateOfAniversary"] != DBNull.Value)
itemObj.DateOfAniversary = DateTime.Parse(dr["DateOfAniversary"].ToString());
if (dr["ContactNumber"] != DBNull.Value)
itemObj.ContactNumber = Int32.Parse(dr["ContactNumber"].ToString());
if (dr["Landline"] != DBNull.Value)
itemObj.Landline = Int32.Parse(dr["Landline"].ToString());
if (dr["CompanyProfile"] != DBNull.Value)
itemObj.CompanyProfile = dr["CompanyProfile"].ToString();
if (dr["JoinningDate"] != DBNull.Value)
itemObj.JoinningDate = DateTime.Parse(dr["JoinningDate"].ToString());
if (dr["CreatedOn"] != DBNull.Value)
itemObj.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
if (dr["CreatedByID"] != DBNull.Value)
itemObj.CreatedByID = Int32.Parse(dr["CreatedByID"].ToString());
if (dr["ModifiedOn"] != DBNull.Value)
itemObj.ModifiedOn = DateTime.Parse(dr["ModifiedOn"].ToString());
if (dr["ModifiedByID"] != DBNull.Value)
itemObj.ModifiedByID = Int32.Parse(dr["ModifiedByID"].ToString());
if (dr["IsActive"] != DBNull.Value)
itemObj.IsActive = Boolean.Parse(dr["IsActive"].ToString());
return itemObj;
}
public static int Update(BOEmployee entry)
{
return tblEmployeeDBManager.Save(entry, false);
}
public static int Save(BOEmployee entry)
{
return tblEmployeeDBManager.Save(entry, true);
}
public static int Save(BOEmployee entry, bool adding)
{
return tblEmployeeDBManager.Save(entry, adding);
}
public static int Save(BOEmployee entry, bool adding)
{
tblEmployee tblObj = new tblEmployee();
DataRow newRow = tblObj.Table().NewRow();
newRow[tblEmployee.EMPLOYEEID_FIELD] = entry.EmployeeID;
newRow[tblEmployee.FIRSTNAME_FIELD] = entry.FirstName;
newRow[tblEmployee.LASTNAME_FIELD] = entry.LastName;
newRow[tblEmployee.EMAILADDRESS_FIELD] = entry.EmailAddress;
newRow[tblEmployee.PASSWORD_FIELD] = entry.Password;
newRow[tblEmployee.EMPLOYEETYPE_FIELD] = entry.EmployeeType;
if(entry.CreatedOn.Equals(new DateTime()))
newRow[tblEmployee.CREATEDON_FIELD] = DBNull.Value;
else
newRow[tblEmployee.CREATEDON_FIELD] = entry.CreatedOn;
newRow[tblEmployee.CREATEDBYID_FIELD] = entry.CreatedByID;
if(entry.ModifiedOn.Equals(new DateTime()))
newRow[tblEmployee.MODIFIEDON_FIELD] = DBNull.Value;
else
newRow[tblEmployee.MODIFIEDON_FIELD] = entry.ModifiedOn;
newRow[tblEmployee.MODIFIEDBYID_FIELD] = entry.ModifiedByID;
newRow[tblEmployee.ISACTIVE_FIELD] = entry.IsActive;
if(adding)
return tblObj.AddToTable(newRow);
else
return tblObj.UpdateTable(newRow);
}
private static BOEmployee FillDataRecord(DataRow dr)
{
BOEmployee itemObj = new BOEmployee();
if(dr["EmployeeID"] != DBNull.Value)
itemObj.EmployeeID = Int32.Parse(dr["EmployeeID"].ToString());
if(dr["FirstName"] != DBNull.Value)
itemObj.FirstName = dr["FirstName"].ToString();
if(dr["LastName"] != DBNull.Value)
itemObj.LastName = dr["LastName"].ToString();
if(dr["EmailAddress"] != DBNull.Value)
itemObj.EmailAddress = dr["EmailAddress"].ToString();
if(dr["Password"] != DBNull.Value)
itemObj.Password = dr["Password"].ToString();
if(dr["EmployeeType"] != DBNull.Value)
itemObj.EmployeeType = Boolean.Parse(dr["EmployeeType"].ToString());
if(dr["CreatedOn"] != DBNull.Value)
itemObj.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
if(dr["CreatedByID"] != DBNull.Value)
itemObj.CreatedByID = Int32.Parse(dr["CreatedByID"].ToString());
if(dr["ModifiedOn"] != DBNull.Value)
itemObj.ModifiedOn = DateTime.Parse(dr["ModifiedOn"].ToString());
if(dr["ModifiedByID"] != DBNull.Value)
itemObj.ModifiedByID = Int32.Parse(dr["ModifiedByID"].ToString());
if(dr["IsActive"] != DBNull.Value)
itemObj.IsActive = Boolean.Parse(dr["IsActive"].ToString());
return itemObj;
}
