public static Empm Read(string connectionString, string userName, string password, Dber dberr)
{
try
{
var employeeMasterObject = new Empm();
var query = string.Format("select * from empm where emp_uname = '{0}' and emp_pass= '******' ", userName, password);
var data = DbAccess.ExecuteQuery(connectionString, CommandType.Text, query);
//assign the data object to employee master object
if (data.Tables[0].Rows.Count > 0)
{
employeeMasterObject.emp_no = data.Tables[0].Rows[0]["emp_id"].ToString();
employeeMasterObject.emp_fname = data.Tables[0].Rows[0]["emp_fname"].ToString();
employeeMasterObject.emp_mname = data.Tables[0].Rows[0]["emp_mname"].ToString();
employeeMasterObject.emp_lname = data.Tables[0].Rows[0]["emp_lname"].ToString();
employeeMasterObject.emp_phn = data.Tables[0].Rows[0]["emp_phn"].ToString();
employeeMasterObject.emp_addr1 = data.Tables[0].Rows[0]["emp_addr1"].ToString();
employeeMasterObject.emp_addr2 = data.Tables[0].Rows[0]["emp_addr2"].ToString();
employeeMasterObject.emp_city = data.Tables[0].Rows[0]["emp_city"].ToString();
employeeMasterObject.emp_state = data.Tables[0].Rows[0]["emp_state"].ToString();
employeeMasterObject.emp_zip = data.Tables[0].Rows[0]["emp_zip"].ToString();
employeeMasterObject.emp_uname = data.Tables[0].Rows[0]["emp_uname"].ToString();
employeeMasterObject.emp_pass = data.Tables[0].Rows[0]["emp_pass"].ToString();
employeeMasterObject.emp_pvg = Convert.ToInt32(data.Tables[0].Rows[0]["emp_pvg"]);
employeeMasterObject.emp_mngr = data.Tables[0].Rows[0]["emp_mngr"].ToString();
employeeMasterObject.emp_brnch = data.Tables[0].Rows[0]["emp_brnch"].ToString();
employeeMasterObject.emp_secq1 = data.Tables[0].Rows[0]["emp_secq1"].ToString();
employeeMasterObject.emp_ans1 = data.Tables[0].Rows[0]["emp_ans1"].ToString();
employeeMasterObject.emp_secq2 = data.Tables[0].Rows[0]["emp_secq2"].ToString();
employeeMasterObject.emp_ans2 = data.Tables[0].Rows[0]["emp_ans2"].ToString();
employeeMasterObject.emp_ans2 = data.Tables[0].Rows[0]["emp_ans2"].ToString();
employeeMasterObject.emp_email = data.Tables[0].Rows[0]["emp_email"].ToString();
return employeeMasterObject;
}
else
{
dberr.setError(Mnemonics.DbErrorCodes.DBERR_EMPM_NOFIND);
return null;
}
}
catch (Exception ex)
{
dberr.setError(Mnemonics.DbErrorCodes.DBERR_EMPM_NOFIND);
return null;
}
}
public static bool Update(string connectionString, Empm dataObject, Dber dberr)
{
throw new NotImplementedException();
}
private static Empm GetEmpmObject(DataRow row)
{
try
{
var employeeMasterObject = new Empm();
employeeMasterObject.emp_no = row["emp_id"].ToString();
employeeMasterObject.emp_fname = row["emp_fname"].ToString();
employeeMasterObject.emp_mname = row["emp_mname"].ToString();
employeeMasterObject.emp_lname = row["emp_lname"].ToString();
employeeMasterObject.emp_phn = row["emp_phn"].ToString();
employeeMasterObject.emp_addr1 = row["emp_addr1"].ToString();
employeeMasterObject.emp_addr2 = row["emp_addr2"].ToString();
employeeMasterObject.emp_city = row["emp_city"].ToString();
employeeMasterObject.emp_state = row["emp_state"].ToString();
employeeMasterObject.emp_zip = row["emp_zip"].ToString();
employeeMasterObject.emp_uname = row["emp_uname"].ToString();
employeeMasterObject.emp_pass = row["emp_pass"].ToString();
employeeMasterObject.emp_pvg = Convert.ToInt32(row["emp_pvg"]);
employeeMasterObject.emp_mngr = row["emp_mngr"].ToString();
employeeMasterObject.emp_brnch = row["emp_brnch"].ToString();
employeeMasterObject.emp_secq1 = row["emp_secq1"].ToString();
employeeMasterObject.emp_ans1 = row["emp_ans1"].ToString();
employeeMasterObject.emp_secq2 = row["emp_secq2"].ToString();
employeeMasterObject.emp_ans2 = row["emp_ans2"].ToString();
employeeMasterObject.emp_ans2 = row["emp_ans2"].ToString();
employeeMasterObject.emp_email = row["emp_email"].ToString();
return employeeMasterObject;
}
catch (Exception ex)
{
return null;
}
}
public static int Create(string connectionString, Empm dataObject, Dber dberr)
{
try
{
var query = string.Format(@"INSERT INTO [SBS].[dbo].[EMPM]
([EMP_FNAME],[EMP_MNAME],[EMP_LNAME],[EMP_ADDR1],[EMP_ADDR2]
,[EMP_ZIP],[EMP_CITY],[EMP_STATE],[EMP_BRNCH],[EMP_PHN],[EMP_EMAIL]
,[EMP_MNGR],[EMP_PVG],[EMP_SECQ1],[EMP_ANS1],[EMP_SECQ2],[EMP_ANS2]
,[EMP_UNAME],[EMP_PASS])
OUTPUT INSERTED.EMP_ID
VALUES
('{0}' ,'{1}' ,'{2}' ,'{3}','{4}' ,'{5}','{6}' ,'{7}' ,'{8}' ,'{9}' ,'{10}' ,'{11}' ,'{12}' ,'{13}'
,'{14}' ,'{15}' ,'{16}' ,'{17}', '{18}')",
dataObject.emp_fname, dataObject.emp_mname, dataObject.emp_lname, dataObject.emp_addr1, dataObject.emp_addr2,
dataObject.emp_zip, dataObject.emp_city, dataObject.emp_state, dataObject.emp_brnch, dataObject.emp_phn,
dataObject.emp_email, dataObject.emp_mngr, dataObject.emp_pvg, dataObject.emp_secq1, dataObject.emp_ans1,
dataObject.emp_secq2, dataObject.emp_ans2, dataObject.emp_uname, dataObject.emp_pass);
var employeeId = (int)DbAccess.ExecuteScalar(connectionString, CommandType.Text, query);
UpdateUserId(connectionString, employeeId, dberr);
UpdatePKIInformation(connectionString, employeeId.ToString(), dberr);
return employeeId;
}
catch (Exception ex)
{
dberr.setError(Mnemonics.DbErrorCodes.DBERR_ACTM_NOFIND);
return -1;
}
}
