public FrmStationMap()
{
InitializeComponent();
publicStreetGroup = this;
setImages();
ToolStripEvent();
Load += OnFormLoad;
iTransType = TransactionTypeCode.Null;
OnFormLoad(null, null);
bttnUpdate.Click += bttnUpdate_Click;
btnReport.Click += btnReport_Click;
}
void ImportCsvFile()
{
//if (dateTimePicker1.Value >= DateTime.Now.Date)
//{
// Common.setMessageBox("Transaction Date Must be Less than Today's Date", Program.ApplicationName, 3);
// return;
//}
//else
if (_backupdb.doBackUp("TaxSmartSuiteRevised") == "Done")
{
bool bResponse = false;
bool isError = false;
using (WaitDialogForm form = new WaitDialogForm())
{
//strDate = GetValidateionDate;
//if (string.IsNullOrEmpty(strDate))
// return;
//if (!ValidateDate()) return;
if (CheuqeOption == "0001")
{//import normal paydirect record
try
{
strDate = GetValidateionDate;
if (string.IsNullOrEmpty(strDate))
{
return;
}
if (!ValidateDate())
{
return;
}
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
command = new SqlCommand("insertCollectionReportPay", connect)
{
CommandType = CommandType.StoredProcedure
};
command.Parameters.Add(new SqlParameter("@CollectionReport_Temp", SqlDbType.Structured)).Value = Dt;
command.Parameters.Add(new SqlParameter("@User", SqlDbType.VarChar)).Value = user;
command.Parameters.Add(new SqlParameter("@ValidateDate", SqlDbType.VarChar)).Value = strDate;
//command.Parameters.Add(new SqlParameter("@DateValidate", SqlDbType.DateTime)).Value = dateTimePicker1.Value;
command.CommandTimeout = 10000;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
adp = new SqlDataAdapter(command);
adp.Fill(ds);
Dts = ds.Tables[0];
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "02")
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 3);
isError = true;
goto Map;
}
bResponse = true;
}
}
}
catch (Exception ex)
{
bResponse = false;
MessageBox.Show(ex.Message, " CSV Import ", MessageBoxButtons.OK, MessageBoxIcon.Error); return;
}
}
if (CheuqeOption.ToString() == "0003")
{
//update cheque bank status in the collection report table
try
{
strDate = GetValidateionDate;
if (string.IsNullOrEmpty(strDate))
{
return;
}
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
command = new SqlCommand("UpdateCollectionChequeStatus", connect)
{
CommandType = CommandType.StoredProcedure
};
command.Parameters.Add(new SqlParameter("@CollectionDownloadCredentials_Temp", SqlDbType.Structured)).Value = Dt;
command.Parameters.Add(new SqlParameter("@User", SqlDbType.VarChar)).Value = user;
command.Parameters.Add(new SqlParameter("@OnlineCurrentDate", SqlDbType.VarChar)).Value = strDate;//dateTimePicker1.Value.ToString("MM/dd/yyyy");
command.CommandTimeout = 10000;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
adp = new SqlDataAdapter(command);
adp.Fill(ds);
//if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "-1")
// MessageBox.Show(ds.Tables[0].Rows[0]["returnMessage"].ToString(), " CSV Import ", MessageBoxButtons.OK, MessageBoxIcon.Error);
Dts = ds.Tables[0];
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() != "00")
{
if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "04")
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString().Replace("###", dateTimePicker1.Value.ToLongDateString()), Program.ApplicationName, 3);
}
else
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 3);
}
return;
}
bResponse = true;
}
}
}
catch (Exception ex)
{
bResponse = false;
MessageBox.Show(ex.Message, " CSV Import ", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
}
Map:
if (isError)
{
using (FrmStationMap frmStationMap = new FrmStationMap())
{
frmStationMap.ShowDialog();
}
}
else
{
if (bResponse && Dts.Rows[0][0].ToString() == "00")
{
MessageBox.Show(Dts.Rows[0]["returnMessage"].ToString(), " CSV Import ", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
MessageBox.Show("Error...", " CSV Import ", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
}
else
{
Common.setMessageBox("Could not create backup", Program.ApplicationName, 3);
return;
}
}
