public List <DepartmentGOM> Show()
{
Query = "SELECT * FROM Department";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <DepartmentGOM> departments = new List <DepartmentGOM>();
while (Reader.Read())
{
DepartmentGOM aDepartmentGom = new DepartmentGOM();
aDepartmentGom.DeptId = Convert.ToInt32(Reader["DepartmentId"].ToString());
aDepartmentGom.DeptCode = Reader["DepartmentCode"].ToString();
aDepartmentGom.DeptName = Reader["DepartmentName"].ToString();
departments.Add(aDepartmentGom);
}
Connection.Close();
Reader.Close();
return(departments);
}
public int SaveDept(DepartmentGOM aDepartmentGom)
{
Connection = new SqlConnection(connectionString);
Query = "INSERT INTO Department(DepartmentCode,DepartmentName) VALUES(@DeptCode,@DeptName)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("DeptCode", SqlDbType.VarChar);
Command.Parameters["DeptCode"].Value = aDepartmentGom.DeptCode;
Command.Parameters.Add("DeptName", SqlDbType.VarChar);
Command.Parameters["DeptName"].Value = aDepartmentGom.DeptName;
Connection.Open();
int rowAffected = 0;
try
{
rowAffected = Command.ExecuteNonQuery();
}
catch
{
rowAffected = -999;
}
Connection.Close();
return(rowAffected);
}
public string SaveDept(DepartmentGOM aDepartmentGom)
{
string msg = "Insertion Failed";
int rowAffected = _aSaveDeptGatewayGom.SaveDept(aDepartmentGom);
if (rowAffected > 0)
{
msg = "Data Successfully Inserted";
}
return(msg);
}
public ActionResult Index(DepartmentGOM aDepartmentGom)
{
DeptUniqueManagerGOM unique = new DeptUniqueManagerGOM();
string msg = unique.CheckUnique(aDepartmentGom);
ViewBag.msg = msg;
if (msg == null)
{
SaveDeptManagerGOM aSaveDeptManagerGom = new SaveDeptManagerGOM();
msg = aSaveDeptManagerGom.SaveDept(aDepartmentGom);
ViewBag.msg = msg;
}
return(View());
}
public string CheckUnique(DepartmentGOM aDepartmentGom)
{
string msg = null;
DepartmentGOM d = unique.CheckUnique(aDepartmentGom);
if (d.DeptCode != null)
{
msg = "Please Insert an Unique Department Code";
}
if (d.DeptName != null)
{
msg = "Please Insert an Unique Department Name";
}
return(msg);
}
public DepartmentGOM CheckUnique(DepartmentGOM aDepartmentGom)
{
Query = "SELECT * FROM Department WHERE DepartmentCode=@DeptCode OR DepartmentName=@DeptName";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("DeptCode", SqlDbType.VarChar);
Command.Parameters["DeptCode"].Value = aDepartmentGom.DeptCode;
Command.Parameters.Add("DeptName", SqlDbType.VarChar);
Command.Parameters["DeptName"].Value = aDepartmentGom.DeptName;
Connection.Open();
Reader = Command.ExecuteReader();
DepartmentGOM departments = new DepartmentGOM();
while (Reader.Read())
{
departments.DeptCode = Reader["DepartmentCode"].ToString();
departments.DeptName = Reader["DepartmentName"].ToString();
}
Connection.Close();
Reader.Close();
if (aDepartmentGom.DeptCode != departments.DeptCode)
{
departments.DeptCode = null;
}
if (aDepartmentGom.DeptName != departments.DeptName)
{
departments.DeptName = null;
}
return(departments);
}
public string ShowDeptCode(string deptId)
{
int Id = Convert.ToInt32(deptId);
Query = "SELECT * FROM Department WHERE DepartmentId='" + Id + "'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
DepartmentGOM aDepartmentGom = new DepartmentGOM();
while (Reader.Read())
{
aDepartmentGom.DeptCode = Reader["DepartmentCode"].ToString();
}
Connection.Close();
Reader.Close();
return(aDepartmentGom.DeptCode);
}
