public static int RegisterEmployee(RegisterBO emp)
{
var result = 0;
try
{
var db = DatabaseFactory.CreateDatabase("ConnectionString");
using (var dbcmd = db.GetStoredProcCommand("Proc_InsertEmployeeDetails"))
{
db.AddInParameter(dbcmd, "@EMP_FirstName", DbType.String, emp.firstname);
db.AddInParameter(dbcmd, "@EMP_LastName", DbType.String, emp.lastname);
db.AddInParameter(dbcmd, "@EMP_Password", DbType.String, emp.password);
db.AddInParameter(dbcmd, "@EMP_Gender", DbType.String, emp.gender);
db.AddInParameter(dbcmd, "@EMP_Email", DbType.String, emp.email);
db.AddInParameter(dbcmd, "@EMP_DOB", DbType.String, emp.dob);
db.AddOutParameter(dbcmd, "@Succes", DbType.Int32, 0);
db.ExecuteReader(dbcmd);
result = Convert.ToInt32(db.GetParameterValue(dbcmd, "@Succes"));
}
}
catch (Exception ex)
{
result = 0;
}
return(result);
}
void usersCollection_Filter(object sender, FilterEventArgs e)
{
if (string.IsNullOrEmpty(FilterText))
{
e.Accepted = true;
return;
}
RegisterBO reg = e.Item as RegisterBO;
if (reg.firstname.ToUpper().Contains(FilterText.ToUpper()))
{
e.Accepted = true;
}
else
{
e.Accepted = false;
}
}
public List <RegisterBO> GetEmployeeDetails()
{
List <RegisterBO> det = new List <RegisterBO>();
//write the code here for get the employee list.
using (var dataReader = AssignmentBLL.Authenticate.GetAllEmployeesList())
{
while (dataReader.Read()) // read() moves to next row of read data
{
RegisterBO DetailsModel = new RegisterBO();
DetailsModel.firstname = Convert.ToString(dataReader["First Name"]);
DetailsModel.lastname = (string)dataReader["Last Name"];
DetailsModel.email = (string)dataReader["Email"];
DetailsModel.gender = (string)dataReader["Gender"];
//DetailsModel.dob = Convert.ToDateTime(dataReader["DOB"]).ToString("dd-mm-yyyy");
det.Add(DetailsModel);
}
dataReader.Close();
}
return(det);
}
public void RegisterApplication(RegisterBO registerBO)
{
if (registerBO.firstName != null)
{
firstName.Clear();
firstName.SendKeys(registerBO.firstName);
}
if (registerBO.lastName != null)
{
lastName.Clear();
lastName.SendKeys(registerBO.lastName);
}
if (registerBO.email != null)
{
email.Clear();
email.SendKeys(registerBO.email);
}
if (registerBO.telephone != null)
{
telephone.Clear();
telephone.SendKeys(registerBO.company);
}
if (registerBO.fax != null)
{
fax.Clear();
fax.SendKeys(registerBO.company);
}
if (registerBO.company != null)
{
company.Clear();
company.SendKeys(registerBO.company);
}
if (registerBO.address1 != null)
{
address1.Clear();
address1.SendKeys(registerBO.address1);
}
if (registerBO.address2 != null)
{
address2.Clear();
address2.SendKeys(registerBO.address2);
}
if (registerBO.city != null)
{
city.Clear();
city.SendKeys(registerBO.city);
}
if (registerBO.postCode != null)
{
postCode.Clear();
postCode.SendKeys(registerBO.postCode);
}
if (registerBO.country != null)
{
var select = new SelectElement(country);
select.SelectByText(registerBO.country);
}
if (registerBO.regionState != null)
{
//waiting for regionState text to be available
var wait = new WebDriverWait(driver, TimeSpan.FromSeconds(2));
wait.Until(ExpectedConditions.ElementIsVisible(By.XPath("//*[text()='" + registerBO.regionState + "']")));
var select = new SelectElement(regionState);
select.SelectByText(registerBO.regionState);
}
if (registerBO.password != null)
{
password.Clear();
password.SendKeys(registerBO.password);
}
if (registerBO.passwordConfirm != null)
{
passwordConfirm.Clear();
passwordConfirm.SendKeys(registerBO.passwordConfirm);
}
if (registerBO.subscribe == true)
{
subscribeYes.Click();
}
else
{
subscribeNo.Click();
}
if (registerBO.agreePrivacyPolicy == true)
{
privacyPolicy.Click();
}
confirmBtn.Click();
}
