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