private ReportDataSet.AddressesDataTable GetData(string datefrom, string dateto)
{
string strConnString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
Console.WriteLine(strConnString);
MySqlConnection conn = new MySqlConnection(strConnString);
var validatedt = new ReportDataSet.AddressesDataTable();
//string connStr = "server=localhost;user=root;database=world;port=3306;password=******";
try
{
Console.WriteLine("Connecting to MySQL...");
conn.Open();
string sql = @"SELECT a.TRANS_CODE, B.CUST_CODE, B.CUST_NAME, B.ADDRESS AS CUST_ADDRESS, B.PHONE1 AS CUST_PHONE1,
B.PHONE2 AS CUST_PHONE2, C.OLSHOP_NAME,
d.COURIER_DETAIL, e.COST_DESC FROM TRANSACTION_IN_DATA A LEFT
JOIN CUST_DATA B on a.CUST_CODE = b.CUST_CODE
left join mt_olshop c on a.OLSHOP_CODE = c.OLSHOP_CODE LEFT
JOIN COURIER_DATA d on a.COURIER_CODE = d.COURIER_CODE LEFT
JOIN courier_cost_data e on a.COST_CODE = e.COST_CODE
AND d.COURIER_CODE = e.COURIER_CODE WHERE A.SENT_STATUS = 'N'";
if (RadCmbListCust.CheckedItems.Count > 0)
{
for (int i = 0; i < RadCmbListCust.CheckedItems.Count; i++)
{
if (i == 0)
{
sql += "AND b.CUST_CODE = '" + RadCmbListCust.CheckedItems[i].Value + "'";
}
else
{
sql += "OR b.CUST_CODE = '" + RadCmbListCust.CheckedItems[i].Value + "'";
}
}
}
daCountry = new MySqlDataAdapter(sql, conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(daCountry);
dsCountry = new DataSet();
daCountry.Fill(dsCountry, "mt_prod");
daCountry.Fill(validatedt);
}
catch (Exception ex)
{
//ShowMessage("Error: " + ex.Message);
}
return(validatedt);
conn.Close();
Console.WriteLine("Done.");
}
private bool update(ReportDataSet.AddressesDataTable dt)
{
bool result = true;
string strConnString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
Console.WriteLine(strConnString);
MySqlConnection conn = new MySqlConnection(strConnString);
for (int i = 0; i < dt.Rows.Count; i++)
{
try
{
conn.Open();
//string SID = lblSID.Text;
MySqlCommand cmd = new MySqlCommand("update TRANSACTION_IN_DATA Set SENT_STATUS = 'Y', UPDATE_DATE = @datetime, UPDATE_USER = @user where CUST_CODE = @code", conn);
//MySqlCommand cmd = new MySqlCommand("INSERT INTO TRANSACTION_HDR (TRANS_CODE_HDR, TRANS_CODE_DESC, UPDATE_DATE) VALUES ('', @desc, @datetime )", conn);
cmd.Parameters.AddWithValue("@code", Convert.ToInt16(dt.Rows[i]["CUST_CODE"]));
cmd.Parameters.AddWithValue("@user", Session["id"].ToString());
cmd.Parameters.AddWithValue("@datetime", DateTime.Now);
cmd.ExecuteNonQuery();
cmd.Dispose();
//retrieve();
//LoadDataInNotification("Data has been Updated", "Update Success");
//ShowMessage("Hdr Data update Successfully......!");
}
catch (MySqlException ex)
{
result = false;
//ShowMessage("Error: " + ex.Message);
}
finally
{
conn.Close();
}
}
return(result);
}
