public bool updatedelstatus()
{
try
{
String sql = "";
foreach (DataGridViewRow gRow in gridSDRRUpdate.Rows)
{
Dictionary <String, Object> param = new Dictionary <String, Object>();
param.Add("sdrrno", _sdrrno);
param.Add("invoice_no", gRow.Cells["invoiceno"].Value);
param.Add("datedel", gRow.Cells["datedel"].Value);
param.Add("delstat", gRow.Cells["status"].Value);
param.Add("dateupdated", DateTime.Now.Date);
param.Add("remarks", gRow.Cells["remarks"].Value);
List <String> primary = new List <string>();
primary.Add("sdrrno");
primary.Add("invoice_no");
sql += DataSupport.GetUpdate("GLOBAL_ProductTrans", param, primary);
}
if (sql != "")
{
Utils.ExecuteNonQuery(sql, null);
}
DevComponents.DotNetBar.MessageBoxEx.Show("Delivery Status successfully updated");
return(true);
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(String.Format("{0}\nUnable to update the transaction", ex.Message));
return(false);
}
}
public bool update()
{
try
{
Dictionary <String, Object> Params = new Dictionary <String, Object>();
Params.Add("_nudindex", _nudindex);
Params.Add("customer_name", cboCustomer.Text);
Params.Add("totalamount", totalinvoicev);
Params.Add("terms", cboTerms.Text);
Params.Add("clientname", cboclientname.SelectedValue);
Params.Add("deldate", dtdelivered.Value.ToShortDateString());
Params.Add("dateprepared", dtprepared.Value.ToShortDateString());
Params.Add("datestamp", DateTime.Now.Date);
Params.Add("delman", txtdelman.Text);
List <String> primary = new List <String>();
primary.Add("_nudindex");
string sql = DataSupport.GetUpdate("global_NUD", Params, primary);
foreach (DataGridViewRow row in nudgrid.Rows)
{
if (row.IsNewRow)
{
continue;
}
Dictionary <String, Object> Param1 = new Dictionary <String, Object>();
Param1.Add("_index", row.Cells["index"].Value.ToString().Trim());
Param1.Add("invoice_no", row.Cells["invoice_no"].Value.ToString().Trim());
Param1.Add("invoice_date", row.Cells["invoice_date"].Value.ToString().Trim());
Param1.Add("amount", row.Cells["nudvalue"].Value.ToString().Trim());
Param1.Add("reason", row.Cells["reason"].Value.ToString().Trim());
Param1.Add("delstat", row.Cells["delstat"].Value.ToString().Trim());
Param1.Add("datestamp", DateTime.Now.Date);
Param1.Add("paidby", row.Cells["account"].Value.ToString().Trim());
Param1.Add("sdrrno", row.Cells["sdrrno"].Value.ToString().Trim());
primary = new List <String>();
primary.Add("_index");
sql += DataSupport.GetUpdate("global_NUDDetails", Param1, primary);
}
Utils.ExecuteNonQuery(sql, null);
DevComponents.DotNetBar.MessageBoxEx.Show("Update Complete");
return(true);
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message + " \n Please Report this to the programmer!");
return(false);
}
}
