public Boolean updateCompAddress(companyaddress ca)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update CompanyAddress set AddressType = " + ca.AddressType +
" ,Address = '" + ca.Address.Replace("'", "''") + "',Status=" + ca.Status +
" where RowID=" + ca.RowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "CompanyAddress", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public List <companyaddress> getCompAddList()
{
companyaddress ca;
List <companyaddress> AddList = new List <companyaddress>();
try
{
SqlConnection conn = new SqlConnection(Login.connString);
string query = "select a.RowID,a.CompanyID, b.CompanyName,a.AddressType,a.Address,a.Status,a.CreateTime,a.CreateUser " +
"from CompanyAddress a,CompanyDetail b where a.CompanyID = b.CompanyID order by a.CompanyID";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ca = new companyaddress();
ca.RowID = reader.GetInt32(0);
ca.CompanyID = reader.GetInt32(1);
ca.CompanyName = reader.GetString(2);
ca.AddressType = reader.GetInt32(3);
ca.Address = reader.GetString(4);
ca.Status = reader.GetInt32(5);
ca.CreateTime = reader.GetDateTime(6);
ca.CreateUser = reader.GetString(7);
AddList.Add(ca);
}
conn.Close();
}
catch (Exception)
{
MessageBox.Show("Error querying Company Address");
}
return(AddList);
}
public Boolean insertCompAddress(companyaddress ca)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into CompanyAddress (CompanyID,AddressType,Address," +
"Status,CreateTime,CreateUser)" +
" values (" +
ca.CompanyID + "," +
ca.AddressType + "," +
"'" + ca.Address + "'," +
ca.Status + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "CompanyAddress", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean validateCompanyAdd(companyaddress ca)
{
Boolean status = true;
try
{
if (ca.CompanyID == 0)
{
return(false);
}
if (ca.AddressType == 0)
{
return(false);
}
if (ca.Address.Trim().Length == 0 || ca.Address == null)
{
return(false);
}
}
catch (Exception)
{
}
return(status);
}