public static SubDepartment[] GetSubDepartments(Connection cnConnection, int intDepartmentsArg)
{
SubDepartment[] depSubDepartments;
int intRowsCount = 0;
SqlConnection scConnection = new SqlConnection(cnConnection.strConnectionStringPty);
SqlCommand cmSubDepartments = new SqlCommand("", scConnection);
cmSubDepartments.Connection = scConnection;
cmSubDepartments.CommandText =
string.Format("SELECT * FROM tabSubDepartments WHERE bitIsActual=1 AND intDepartment={0} ORDER BY nvcName", intDepartmentsArg);
scConnection.Open();
SqlDataReader drSubDepartments = cmSubDepartments.ExecuteReader();
while (drSubDepartments.Read())
{
++intRowsCount;
}
drSubDepartments.Close();
depSubDepartments = new SubDepartment[intRowsCount];
drSubDepartments = cmSubDepartments.ExecuteReader();
intRowsCount = 0;
while (drSubDepartments.Read())
{
depSubDepartments[intRowsCount] = new SubDepartment();
depSubDepartments[intRowsCount].intDepartmnt = (int)drSubDepartments["intDepartment"];
depSubDepartments[intRowsCount].strName = drSubDepartments["nvcName"].ToString();
depSubDepartments[intRowsCount].intNumber = (int)drSubDepartments["intNumber"];
++intRowsCount;
}
return(depSubDepartments);
}
public static bool Insert(Connection cnConnection, SubDepartment sdInsertArg)
{
bool bolResultLoc = false;
SqlConnection scConnection = new SqlConnection(cnConnection.strConnectionStringPty);
SqlCommand cmSubDepartments = new SqlCommand();
cmSubDepartments.Connection = scConnection;
cmSubDepartments.CommandText = String.Format("INSERT INTO tabDepartments (intDepartment,nvcName, intNumber) VALUES ({0},N'{1}',{2})",
sdInsertArg.intDepartmnt, sdInsertArg.strName, NextNumber(cnConnection));
scConnection.Open();
if (cmSubDepartments.ExecuteNonQuery() >= 1)
{
bolResultLoc = true;
}
scConnection.Close();
return(bolResultLoc);
}
public static bool Update(Connection cnConnection, SubDepartment sdUpadateArg)
{
bool bolResultLoc = false;
SqlConnection scConnection = new SqlConnection(cnConnection.strConnectionStringPty);
SqlCommand cmSubDepartments = new SqlCommand();
cmSubDepartments.Connection = scConnection;
cmSubDepartments.CommandText = String.Format("UPDATE tabSubDepartments SET intDepartment={0}, nvcName=N'{1}', intNumber={2} WHERE intID={3}",
sdUpadateArg.intDepartmnt, sdUpadateArg.strName, sdUpadateArg.intNumber, sdUpadateArg.intID);
scConnection.Open();
if (cmSubDepartments.ExecuteNonQuery() >= 1)
{
bolResultLoc = true;
}
scConnection.Close();
return(bolResultLoc);
}
public static string GetNameByDepartmentAndNumber(Connection cnConnection, SubDepartment sdSearchArg)
{
String strNameLoc = "";
SqlConnection scConnection = new SqlConnection(cnConnection.strConnectionStringPty);
SqlCommand cmSubDepartments = new SqlCommand();
cmSubDepartments.Connection = scConnection;
cmSubDepartments.CommandText = String.Format("SELECT nvcName FROM tabShifts WHERE intDepartment={0}, intNumber={1}",
sdSearchArg.intDepartmnt, sdSearchArg.intNumber);
scConnection.Open();
SqlDataReader drSubDepartment = cmSubDepartments.ExecuteReader();
if (drSubDepartment.Read())
{
strNameLoc = drSubDepartment["nvcName"].ToString();
}
drSubDepartment.Close();
scConnection.Close();
return(strNameLoc);
}