//............................Get All assign Hardware to a single User..............................
public List <HardwareAllocated> GetUserAssignHardwareByUserId(int UserId)
{
List <HardwareAllocated> hardwareAllocatedItems = new List <HardwareAllocated>();
try
{
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("select b.id,c.name, a.hardwareType,b.allocationDate from tblHardwareType a inner join tblHardwareAllocated b on a.hardwareTypeId = b.hardwareTypeId inner join tblUsers c on b.userId = c.userId where b.userId=" + UserId, con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
HardwareAllocated hardwareAllocated = new HardwareAllocated();
hardwareAllocated.id = Convert.ToInt32(rdr["id"]);
hardwareAllocated.name = rdr["name"].ToString();
hardwareAllocated.hardwareType = rdr["hardwareType"].ToString();
hardwareAllocated.allocationDate = Convert.ToDateTime(rdr["allocationDate"]);
hardwareAllocatedItems.Add(hardwareAllocated);
}
con.Close();
}
}
catch
{
throw;
}
return(hardwareAllocatedItems);
}
//To Add new Item record
public int AddIssueHardwarer(HardwareAllocated hardwareAllocated)
{
try
{
using (SqlConnection con = new SqlConnection(connectionString))
{
//string Query = string.Format("insert into tblHardwareAllocated (hardwareTypeId,userId,allocationDate) values ({0},{1},'{2}')", hardwareAllocated.hardwareTypeId,hardwareAllocated.userId,DateTime.Now);
SqlCommand cmd = new SqlCommand("PS_AllottingHardware", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@userId", hardwareAllocated.userId);
cmd.Parameters.AddWithValue("@hardwareTypeId", hardwareAllocated.hardwareTypeId);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
catch (Exception ex)
{
throw;
}
return(1);
}