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); }