public static void InsertTable(ENTFRMFIRM firm)
{
try
{
con = SQL.GetConnection();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd = SQL.SetCommand("INSERT INTO FRM_FIRM (ID,NAME,DESCRIPTION,CITYID,DISTRICTID,ADDRESS) VALUES (@ID,@NAME,@DESCRIPTION,@CITYID,@DISTRICTID,@ADDRESS)", con);
cmd.Parameters.AddWithValue("@ID", firm.ID);
cmd.Parameters.AddWithValue("@NAME", firm.NAME);
cmd.Parameters.AddWithValue("@DESCRIPTION", firm.DESCRIPTION);
cmd.Parameters.AddWithValue("@CITYID", firm.CITYID);
cmd.Parameters.AddWithValue("@DISTRICTID", firm.DISTRICTID);
cmd.Parameters.AddWithValue("@ADDRESS", firm.ADDRESS);
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
}
}
public static void Update(ENTFRMFIRM firm)
{
con = SQL.GetConnection();
cmd = SQL.SetCommand("UPDATE FRM_FIRM SET NAME = @NAME,DESCRIPTION=@DESCRIPTION,CITYID=@CITYID,DISTRICTID=@DISTRICTID,ADDRESS=@ADDRESS WHERE ID = @ID", con);
cmd.Parameters.AddWithValue("@NAME", firm.NAME);
cmd.Parameters.AddWithValue("@DESCRIPTION", firm.DESCRIPTION);
cmd.Parameters.AddWithValue("@CITYID", firm.CITYID);
cmd.Parameters.AddWithValue("@DISTRICTID", firm.DISTRICTID);
cmd.Parameters.AddWithValue("@ADDRESS", firm.ADDRESS);
cmd.Parameters.AddWithValue("@ID", firm.ID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public static ENTFRMFIRM GetFirm(Guid ID)
{
con = SQL.GetConnection();
cmd = SQL.SetCommand("SELECT * FROM FRM_FIRM WHERE ID=@ID", con);
cmd.Parameters.AddWithValue("@ID", ID);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
ENTFRMFIRM firm = null;
while (dr.Read())
{
firm = new ENTFRMFIRM(Guid.Parse(dr["ID"].ToString()), dr["NAME"].ToString(), dr["DESCRIPTION"].ToString(), Convert.ToByte(dr["CITYID"].ToString()), Convert.ToInt16(dr["DISTRICTID"].ToString()), dr["ADDRESS"].ToString());
break;
}
con.Close();
return(firm);
}
