//ActivityLogDB alDB = new ActivityLogDB();
public List <storeempmapping> getStockEmpMapping()
{
storeempmapping sem;
List <storeempmapping> SEMs = new List <storeempmapping>();
try
{
SqlConnection conn = new SqlConnection(Login.connString);
string query = "select a.StoreLocationID, b.Description,a.EmployeeID,c.Name,a.status " +
"from StoreEmpMapping as a " +
"LEFT OUTER JOIN CatalogueValue as b on a.StoreLocationID = b.CatalogueValueID " +
"LEFT OUTER JOIN Employee as c on a.EmployeeID=c.EmployeeID " +
"order by a.StoreLocationID,c.Name";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
sem = new storeempmapping();
sem.StoreLocationID = reader.GetString(0);
sem.Description = reader.GetString(1);
sem.EmployeeID = reader.GetString(2);
sem.EmployeeName = reader.GetString(3);
sem.Status = reader.GetInt32(4);
SEMs.Add(sem);
}
conn.Close();
}
catch (Exception)
{
MessageBox.Show("Error Loading StockEmpMappings");
}
return(SEMs);
}
public Boolean validateDocument(storeempmapping sem)
{
Boolean status = true;
try
{
if (sem.StoreLocationID.Trim().Length == 0 || sem.StoreLocationID == null)
{
return(false);
}
if (sem.EmployeeID.Trim().Length == 0 || sem.EmployeeID == null)
{
return(false);
}
}
catch (Exception)
{
}
return(status);
}
