public static void InsertTable(ENTPRJPROJECT prj)
{
try
{
con = SQL.GetConnection();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd = SQL.SetCommand("INSERT INTO VW_PRJ_Project (ID,NAME,TYPEPROJECTSTATUSID,FIRMID) VALUES (@ID,@NAME,@TYPEPROJECTSTATUSID,@FIRMID)", con);
cmd.Parameters.AddWithValue("@ID", prj.ID);
cmd.Parameters.AddWithValue("@NAME", prj.NAME);
cmd.Parameters.AddWithValue("@TYPEPROJECTSTATUSID", prj.TYPEPROJECTSTATUSID);
cmd.Parameters.AddWithValue("@FIRMID", prj.FIRMID);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public static void Update(ENTPRJPROJECT prj)
{
con = SQL.GetConnection();
cmd = SQL.SetCommand("UPDATE PRJ_PROJECT SET NAME = @NAME,DESCRIPTION=@DESCRIPTION,TYPEPROJECTSTATUSID=@TYPEPROJECTSTATUSID,FIRMID=@FIRMID WHERE ID =@ID", con);
cmd.Parameters.AddWithValue("@ID", prj.ID);
cmd.Parameters.AddWithValue("@NAME", prj.NAME);
cmd.Parameters.AddWithValue("@DESCRIPTION", prj.DESCRIPTION);
cmd.Parameters.AddWithValue("@TYPEPROJECTSTATUSID", prj.TYPEPROJECTSTATUSID);
cmd.Parameters.AddWithValue("@FIRMID", prj.FIRMID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public static ENTPRJPROJECT GetProject(Guid ID)
{
con = SQL.GetConnection();
cmd = SQL.SetCommand("SELECT * FROM PRJ_Project WHERE ID=@ID", con);
cmd.Parameters.AddWithValue("@ID", ID);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
ENTPRJPROJECT prj = null;
while (dr.Read())
{
prj = new ENTPRJPROJECT(Guid.Parse(dr["ID"].ToString()), dr["NAME"].ToString(), dr["DESCRIPTION"].ToString(), Byte.Parse(dr["TYPEPROJECTSTATUSID"].ToString()), Guid.Parse(dr["FIRMID"].ToString()));
break;
}
con.Close();
return(prj);
}
public static List <ENTPRJPROJECT> GetAllListTaskID(Guid FIRMID)
{
con = SQL.GetConnection();
cmd = SQL.SetCommand("SELECT * FROM PRJ_PROJECT WHERE FIRMID=@FIRMID", con);
cmd.Parameters.AddWithValue("@FIRMID", FIRMID);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
ENTPRJPROJECT ptsk = null;
List <ENTPRJPROJECT> ptsklist = new List <ENTPRJPROJECT>();
while (dr.Read())
{
ptsk = new ENTPRJPROJECT(Guid.Parse(dr["ID"].ToString()), dr["NAME"].ToString(), dr["DESCRIPTION"].ToString(), Byte.Parse(dr["TYPEPROJECTSTATUSID"].ToString()), Guid.Parse(dr["FIRMID"].ToString()));
ptsklist.Add(ptsk);
}
con.Close();
return(ptsklist);
}
