public M_Employees Selectm_Employee(M_Employees objm_Employee)
{
try
{
strquery = @"select * from M_Employees where empid = '" + objm_Employee.EmpID + "'";
DataRow drType = u_DBConnection.ReturnDataRow(strquery);
if (drType != null)
{
objm_Employee.EmpID = drType["EmpID"].ToString();
objm_Employee.Compcode = drType["Compcode"].ToString();
objm_Employee.Locacode = drType["Locacode"].ToString();
objm_Employee.Name = drType["Name"].ToString();
objm_Employee.TP = drType["TP"].ToString();
objm_Employee.Fax = drType["Fax"].ToString();
objm_Employee.Email = drType["Email"].ToString();
objm_Employee.Address1 = drType["Address1"].ToString();
objm_Employee.Address2 = drType["Address2"].ToString();
objm_Employee.Address3 = drType["Address3"].ToString();
objm_Employee.ContactPerson = drType["ContactPerson"].ToString();
objm_Employee.ContactPersonNo = drType["ContactPersonNo"].ToString();
objm_Employee.CurrentStatus = drType["CurrentStatus"].ToString();
objm_Employee.type = drType["type"].ToString();
return(objm_Employee);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public static string FindExisitingDriver(string locacode)
{
string str = "";
if (M_EmployeeDL.ExistingM_Employee(locacode.Trim()))
{
M_Employees cat = new M_Employees();
cat.EmpID = locacode.Trim();
M_EmployeeDL dl = new M_EmployeeDL();
cat = dl.Selectm_Employee(cat);
str = cat.Name;
}
else
{
str = "<Error!!!>";
}
return(str);
}
/// <summary>
/// Saves a record to the M_Employees table.
/// </summary>
public Boolean Savem_EmployeeSP(M_Employees m_Employee, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_EmployeeSave";
scom.Parameters.Add("@EmpID", SqlDbType.VarChar, 20).Value = m_Employee.EmpID;
scom.Parameters.Add("@Compcode", SqlDbType.VarChar, 20).Value = m_Employee.Compcode;
scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = m_Employee.Locacode;
scom.Parameters.Add("@Name", SqlDbType.VarChar, 100).Value = m_Employee.Name;
scom.Parameters.Add("@TP", SqlDbType.VarChar, 30).Value = m_Employee.TP;
scom.Parameters.Add("@Fax", SqlDbType.VarChar, 30).Value = m_Employee.Fax;
scom.Parameters.Add("@Email", SqlDbType.VarChar, 50).Value = m_Employee.Email;
scom.Parameters.Add("@Address1", SqlDbType.VarChar, 100).Value = m_Employee.Address1;
scom.Parameters.Add("@Address2", SqlDbType.VarChar, 100).Value = m_Employee.Address2;
scom.Parameters.Add("@Address3", SqlDbType.VarChar, 100).Value = m_Employee.Address3;
scom.Parameters.Add("@ContactPerson", SqlDbType.VarChar, 50).Value = m_Employee.ContactPerson;
scom.Parameters.Add("@ContactPersonNo", SqlDbType.VarChar, 50).Value = m_Employee.ContactPersonNo;
scom.Parameters.Add("@CurrentStatus", SqlDbType.VarChar, 20).Value = m_Employee.CurrentStatus;
scom.Parameters.Add("@type", SqlDbType.VarChar, 20).Value = m_Employee.type;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
public List <M_Employees> SelectM_EmployeeMulti(M_Employees objm_Employee2)
{
List <M_Employees> retval = new List <M_Employees>();
try
{
strquery = @"select * from m_Employee where empid = '" + objm_Employee2.EmpID + "'";
DataTable dtm_Employee = u_DBConnection.ReturnDataTable(strquery, CommandType.Text);
foreach (DataRow drType in dtm_Employee.Rows)
{
if (drType != null)
{
M_Employees objm_Employee = new M_Employees();
objm_Employee.EmpID = drType["EmpID"].ToString();
objm_Employee.Compcode = drType["Compcode"].ToString();
objm_Employee.Locacode = drType["Locacode"].ToString();
objm_Employee.Name = drType["Name"].ToString();
objm_Employee.TP = drType["TP"].ToString();
objm_Employee.Fax = drType["Fax"].ToString();
objm_Employee.Email = drType["Email"].ToString();
objm_Employee.Address1 = drType["Address1"].ToString();
objm_Employee.Address2 = drType["Address2"].ToString();
objm_Employee.Address3 = drType["Address3"].ToString();
objm_Employee.ContactPerson = drType["ContactPerson"].ToString();
objm_Employee.ContactPersonNo = drType["ContactPersonNo"].ToString();
objm_Employee.CurrentStatus = drType["CurrentStatus"].ToString();
objm_Employee.type = drType["type"].ToString();
retval.Add(objm_Employee);
}
}
return(retval);
}
catch (Exception ex)
{
throw ex;
}
}
