/// <summary>
/// Add record to database using object.
/// </summary>
/// <param name="prodObj"></param>
/// <returns></returns>
public bool AddRecord(CProductDetail prodObj)
{
DataRow row = m_LocalDatabase.AddRow(prodObj);
bool result = m_Database.AddRecord(constproductTableName, row);
return(result);
}
/// <summary>
/// Update record to database.
/// </summary>
/// <param name="prodObj"></param>
/// <returns></returns>
// SQL Query to Update
// "UPDATE ProductDetail SET ProductName = 'XYZ',ProductWeight = '150 kg',ActualProductWeight = '120 kg',Scale = 2,DateTime ='11/9/2017 1:23 PM' WHERE RecordNo =1"
public bool UpdateProducttable(CProductDetail prodObj)
{
string query = string.Format("UPDATE {0} SET ProductName = '{1}',ProductWeight = '{2}',ActualProductWeight = '{3}',Scale = {4} WHERE RecordNo ={5}", constProductDetailTableName, prodObj.ProductName, prodObj.ProductWeight, prodObj.ActualProductWeight, prodObj.Scale, prodObj.ProductNumber);
try
{
if (m_SqlConnection == null)
{
m_SqlConnection = new SqlCeConnection(GetConnectionString(constProductDetailTableName));
}
if (m_SqlConnection.State == ConnectionState.Broken || m_SqlConnection.State == ConnectionState.Closed)
{
m_SqlConnection.Open();
}
}
catch (Exception ex)
{
#if DEBUG
System.Diagnostics.Debug.WriteLine(ex.StackTrace);
return(false);
#endif
}
return(ExecuteQuery(query));
}
/// <summary>
///
/// </summary>
/// <param name="prodObj"></param>
/// <returns></returns>
public DataRow AddRow(CProductDetail prodObj)
{
DataRow dr = m_ProductDetailDataTable.NewRow();
dr["RecordNo"] = prodObj.ProductNumber;
dr["ProductName"] = prodObj.ProductName;
dr["ProductWeight"] = prodObj.ProductWeight;
dr["ActualProductWeight"] = prodObj.ActualProductWeight;
dr["Scale"] = prodObj.Scale;
m_ProductDetailDataTable.Rows.Add(dr);
return(dr);
}
private CProductDetail ReadValue(DataRow row)
{
CProductDetail prodObj = new CProductDetail();
if (row != null)
{
prodObj.ProductNumber = Convert.ToInt32(row["RecordNo"].ToString());
prodObj.ProductName = row["ProductName"].ToString();
prodObj.ProductWeight = row["ProductWeight"].ToString();
prodObj.ActualProductWeight = row["ActualProductWeight"].ToString();
prodObj.Scale = Convert.ToByte(row["Scale"].ToString());
}
return(prodObj);
}
/// <summary>
/// update record to database.
/// </summary>
/// <param name="prodObj"></param>
/// <returns></returns>
public bool UpdateRecord(CProductDetail prodObj)
{
bool result = m_LocalDatabase.UpdateProducttable(prodObj);
return(result);
}