public static bool SetCoInformation(Connection cnConnection, CoInformation ciResultArg) { bool bolResultLoc = false; SqlConnection scConnection = new SqlConnection(cnConnection.strConnectionStringPty); SqlCommand cmCoInformation = new SqlCommand(); cmCoInformation.Connection = scConnection; cmCoInformation.CommandText = "SELECT intID FROM tabCoInformation"; scConnection.Open(); SqlDataReader drCoInformation = cmCoInformation.ExecuteReader(); if (drCoInformation.Read()) { cmCoInformation.CommandText = String.Format( "UPDATE tabCoInformation SET nvcName=N'{0}', nvcCoType=N'{1}',datRegister='{2}-{3}-{4}',nvcRegisterCode='{5}',nvcCoID='{6}'," + "nvcAddress=N'{7}',nvcPostalCode='{8}',nvcTell='{9}',nvcFax='{10}',nvcTaxID={11}, nvcProvince='{12}', nvcCity='{13}', nvcWebSite='{14}'", ciResultArg.strName, ciResultArg.strCoType, ciResultArg.dtRegister.Year, ciResultArg.dtRegister.Month, ciResultArg.dtRegister.Day, ciResultArg.strRegisterCode, ciResultArg.strCoID, ciResultArg.strAddress, ciResultArg.strPostalCode, ciResultArg.strTell, ciResultArg.strFax, ciResultArg.strTaxID, ciResultArg.strProvince, ciResultArg.strCity, ciResultArg.strWebSite); } else { cmCoInformation.CommandText = String.Format( "INSERT INTO tabCoInformation (nvcName,nvcCoType,datRegister,nvcRegisterCode,nvcCoID,nvcAddress,nvcPostalCode,nvcTell,nvcFax,nvcTaxID,nvcProvince,nvcCity,nvcWebSite)" + " VALUES (N'{0}',N'{1}','{2}-{3}-{4}','{5}','{6}',N'{7}','{8}','{9}','{10}',{11},'{12}','{13}','{14}')", ciResultArg.strName, ciResultArg.strCoType, ciResultArg.dtRegister.Year, ciResultArg.dtRegister.Month, ciResultArg.dtRegister.Day, ciResultArg.strRegisterCode, ciResultArg.strCoID, ciResultArg.strAddress, ciResultArg.strPostalCode, ciResultArg.strTell, ciResultArg.strFax, ciResultArg.strTaxID, ciResultArg.strProvince, ciResultArg.strCity, ciResultArg.strWebSite); } drCoInformation.Close(); if (cmCoInformation.ExecuteNonQuery() >= 1) { bolResultLoc = true; } else { bolResultLoc = false; } scConnection.Close(); return(bolResultLoc); }
public static CoInformation GetCoInformation(Connection cnConnection) { CoInformation ciResultLoc = new CoInformation(); SqlConnection scConnection = new SqlConnection(cnConnection.strConnectionStringPty); SqlCommand cmCoInformation = new SqlCommand(); cmCoInformation.Connection = scConnection; cmCoInformation.CommandText = "SELECT * FROM tabCoInformation"; scConnection.Open(); SqlDataReader drCoInformation = cmCoInformation.ExecuteReader(); if (drCoInformation.Read()) { ciResultLoc.intID = (int)drCoInformation["intID"]; ciResultLoc.strName = drCoInformation["nvcName"].ToString(); ciResultLoc.strCoType = drCoInformation["nvcCoType"].ToString(); ciResultLoc.dtRegister = (DateTime)drCoInformation["datRegister"]; ciResultLoc.strRegisterCode = drCoInformation["nvcRegisterCode"].ToString(); ciResultLoc.strCoID = drCoInformation["nvcCoID"].ToString(); ciResultLoc.strAddress = drCoInformation["nvcAddress"].ToString(); ciResultLoc.strPostalCode = drCoInformation["nvcPostalCode"].ToString(); ciResultLoc.strTell = drCoInformation["nvcTell"].ToString(); ciResultLoc.strFax = drCoInformation["nvcFax"].ToString(); ciResultLoc.strTaxID = drCoInformation["nvcTaxID"].ToString(); ciResultLoc.strProvince = drCoInformation["nvcProvince"].ToString(); ciResultLoc.strCity = drCoInformation["nvcCity"].ToString(); ciResultLoc.strWebSite = drCoInformation["nvcWebSite"].ToString(); } drCoInformation.Close(); scConnection.Close(); return(ciResultLoc); }