private static void InsertData(Po obj, string newDB) { if (CheckData(obj, newDB) == false) { CPo.Insert(obj, new DAL()); } ; }
private static bool CheckData(Po obj, string newDB) { string q = "USE " + newDB + "; "; q += "SELECT * FROM " + PO.PO_TBL + " WHERE " + PO.PO_NAME + " = '" + obj.Po_name + "'; "; using (IDataReader redr = new DAL().Listreader(q)) { while (redr.Read() == true) { obj.Po_id = redr[PO.PO_ID].ToString(); CPo.Update(obj, new DAL()); return(true); } return(false); } }