public void insertKPCTDetailstoWS(string tagno) //inserting data to Web Service
{
if (tagno.ToString() == "")
{
MessageBox.Show("Tag details not found.");
classLog.writeLog("Warning @: KPCT Operations: Tag details not found.");
}
else
{
string truckno = txtTruckNo.Text.Trim().Replace("'", "").Replace(" ", "").ToUpper().ToString();
string savetime = System.DateTime.Now.ToString("dd-MMM-yyyy HH:mm:ss");
string OPLOCid = cmbLocation.SelectedValue.ToString();
try
{
string state = "";
if (classLogin.Connectivity == "WIFI")
{
KPCTSDS.appserver.Service1 details = new KPCTSDS.appserver.Service1();
if (classServerDetails.DBType == "Oracle")
{
state = details.InsertKPCTOperationDetailsOracle(tagno, classLogin.ReaderNo.ToString(), btnSave.Text, savetime, classLogin.User, classLogin.UserType.ToString(), classLogin.Location.ToString(), txtOpQty.Text.ToString(), OPLOCid, "", "", "", "", "", "");
}
}
else if (classLogin.Connectivity == "GPRS")
{
KPCTSDS.WebReference_GPRS.Service1 details = new KPCTSDS.WebReference_GPRS.Service1();
if (classServerDetails.DBType == "Oracle")
{
state = details.InsertKPCTOperationDetailsOracle(tagno, classLogin.ReaderNo.ToString(), btnSave.Text, savetime, classLogin.User, classLogin.UserType.ToString(), classLogin.Location.ToString(), txtOpQty.Text.ToString(), OPLOCid, "", "", "", "", "", "");
}
}
//classLog.writeLog("Info @: KPCT Operations:"+TagRegid+","+ tagno+"," +truckno+","+ trucktype+","+ readerno+","+readerip+","+ User+","+ unregtime);
if (state == "SUCCESS")
{
lblStatus.Text = "Saved..in Online.";
MessageBox.Show("Saved..Successfully.");
WAP3.formKPCTOps r = new WAP3.formKPCTOps(1);
r.btnVerify_Click(TAG);
this.Close();
}
else
{
classLog.writeLog("Error @: KPCT Operations Tally Sheet: Connection failed.");
//insertexitdatatoLocalDB();
}
}
catch (Exception ex)
{
classLog.writeLog("Error @: KPCT Operations TallySheet: Connection failed.");
classLog.writeLog("Exception @: " + ex.ToString());
//insertexitdatatoLocalDB();
}
}
}
public void insertKPCTDetailstoWS(string tagno) //inserting data to Web Service
{
if (tagno.ToString() == "")
{
MessageBox.Show("Tag details not found.");
classLog.writeLog("Warning @: KPCT Operations: Tag details not found.");
}
else
{
string savetime = System.DateTime.Now.ToString("dd-MMM-yyyy HH:mm:ss");
string OPLOCid = cmbLocation.SelectedValue.ToString();
string HandledType;
if (cmbHandledType.Text == "Select")
{
HandledType = "";
}
else
{
HandledType = cmbHandledType.Text;
}
string TallySheetType = "";
if (radioCarting.Checked == true)
{
TallySheetType = radioCarting.Text.ToString();
}
else if (radioStuffing.Checked == true)
{
TallySheetType = radioStuffing.Text.ToString();
}
try
{
string state = "";
if (classLogin.Connectivity == "WIFI")
{
KPCTSDS.appserver.Service1 details = new KPCTSDS.appserver.Service1();
if (classServerDetails.DBType == "Oracle")
{
state = details.InsertKPCTOperationDetailsOracle(tagno, classLogin.ReaderNo.ToString(), btnSave.Text, savetime, classLogin.User, classLogin.UserType.ToString(), classLogin.Location.ToString(), txtOpQty.Text.ToString(), OPLOCid, cmbCargoCondition.SelectedValue.ToString(), cmbWeatherCondition.SelectedValue.ToString(), cmbHandledBy.SelectedValue.ToString(), HandledType, TallySheetType, txtContainerNo.ToString());
}
}
else if (classLogin.Connectivity == "GPRS")
{
KPCTSDS.WebReference_GPRS.Service1 details = new KPCTSDS.WebReference_GPRS.Service1();
if (classServerDetails.DBType == "Oracle")
{
state = details.InsertKPCTOperationDetailsOracle(tagno, classLogin.ReaderNo.ToString(), btnSave.Text, savetime, classLogin.User, classLogin.UserType.ToString(), classLogin.Location.ToString(), txtOpQty.Text.ToString(), OPLOCid, cmbCargoCondition.SelectedValue.ToString(), cmbWeatherCondition.SelectedValue.ToString(), cmbHandledBy.SelectedValue.ToString(), HandledType, TallySheetType, txtContainerNo.ToString());
}
}
//classLog.writeLog("Info @: KPCT Operations:"+TagRegid+","+ tagno+"," +truckno+","+ trucktype+","+ readerno+","+readerip+","+ User+","+ unregtime);
if (state == "SUCCESS")
{
lblStatus.Text = "Saved..in Online.";
MessageBox.Show("Saved..Successfully.");
WAP3.formKPCTOps r = new WAP3.formKPCTOps(1);
r.btnVerify_Click(TAG); r._lbReadInfoReadWrite.Text = "Saved..in Online.";
this.Close();
}
else
{
classLog.writeLog("Error @: KPCT Operations Tally Sheet: " + state.ToString());
lblStatus.Text = state.ToString();
}
}
catch (Exception ex)
{
classLog.writeLog("Error @: KPCT Operations TallySheet: Connection failed.");
classLog.writeLog("Exception @: " + ex.ToString());
lblStatus.Text = "Connection failed.";
}
}
}
public void LoadTallySheetDetails()
{
TSRequired = "";
DataSet ds = new DataSet();
DataSet dstallylocdetails = new DataSet();
if (classLogin.Connectivity == "WIFI")
{
KPCTSDS.appserver.Service1 details = new KPCTSDS.appserver.Service1();
if (classServerDetails.DBVarient == "Oracle")
{
ds = details.GetKPCTTruckTallySheetDetailsOracleNew(TAG);
TSRequired = details.GetKPCTTruckTallySheetValidationDetailsOracle(TAG);
if (btnSave.Text == "CT-YARD/WH OUT")
{
dstallylocdetails = details.GetKPCTTruckTallySheetLocationDetailsOracle(TAG);
cmbLocation.SelectedValue = dstallylocdetails.Tables[0].Rows[0].ItemArray[0];
cmbCargoCondition.SelectedValue = dstallylocdetails.Tables[0].Rows[0].ItemArray[1];
cmbWeatherCondition.SelectedValue = dstallylocdetails.Tables[0].Rows[0].ItemArray[2];
cmbHandledBy.SelectedValue = dstallylocdetails.Tables[0].Rows[0].ItemArray[3];
cmbHandledType.Text = dstallylocdetails.Tables[0].Rows[0].ItemArray[4].ToString();
txtContainerNo.Text = dstallylocdetails.Tables[0].Rows[0].ItemArray[6].ToString();
if (dstallylocdetails.Tables[0].Rows[0].ItemArray[5].ToString() == "Carting")
{
radioCarting.Checked = true;
}
else if (dstallylocdetails.Tables[0].Rows[0].ItemArray[5].ToString() == "Stuffing")
{
radioStuffing.Checked = true;
}
}
}
}
else if (classLogin.Connectivity == "GPRS")
{
KPCTSDS.WebReference_GPRS.Service1 details = new KPCTSDS.WebReference_GPRS.Service1();
if (classServerDetails.DBVarient == "Oracle")
{
ds = details.GetKPCTTruckTallySheetDetailsOracleNew(TAG);
TSRequired = details.GetKPCTTruckTallySheetValidationDetailsOracle(TAG);
if (btnSave.Text == "CT-YARD/WH OUT")
{
dstallylocdetails = details.GetKPCTTruckTallySheetLocationDetailsOracle(TAG);
cmbLocation.SelectedValue = dstallylocdetails.Tables[0].Rows[0].ItemArray[0];
cmbCargoCondition.SelectedValue = dstallylocdetails.Tables[0].Rows[0].ItemArray[1];
cmbWeatherCondition.SelectedValue = dstallylocdetails.Tables[0].Rows[0].ItemArray[2];
cmbHandledBy.SelectedValue = dstallylocdetails.Tables[0].Rows[0].ItemArray[3];
cmbHandledType.Text = dstallylocdetails.Tables[0].Rows[0].ItemArray[4].ToString();
}
}
}
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
dt.Columns.Remove("TRUCKID");
workTable.Rows.Clear();
foreach (DataRow row in dt.Rows)
{
string sno = (dataGridTallySheet.VisibleRowCount + 1).ToString();
object[] o = { sno.ToString(), row["WIDTH"].ToString(), row["HEIGHT"].ToString(), row["COLTOTAL"].ToString() };
workTable.Rows.Add(o);
}
}
dataGridTallySheet.DataSource = workTable;
//Display Total Qty and Status---Start---
int sum = 0;
foreach (DataRow dr in workTable.Rows)
{
sum += Convert.ToInt32(dr["RTotal"]);
}
txtOpQty.Text = txtTotalQty1.Text = sum.ToString();
lblStatus1.Text = lblStatus.Text = workTable.Rows.Count.ToString() + " Rows Inserted.";
}
public void savedetails()
{
if (txtHight.Text == "" || txtWidth.Text == "")
{
lblStatus.Text = "Please Enter Hight&Width details.";
}
else if (txtHight.Text == "0" || txtWidth.Text == "0")
{
lblStatus.Text = "Please Enter Hight&Width details.";
}
else
{
if (classLogin.Connectivity == "WIFI")
{
KPCTSDS.appserver.Service1 details = new KPCTSDS.appserver.Service1();
string WifiConnectionStatus = classConnectivityCheck.WifiSignalStrenthCheck();
if (WifiConnectionStatus == "Success")
{
string ConnectionStatus = classConnectivityCheck.WebServiceConnectivityCheck();
if (ConnectionStatus == "Failed")
{
ConnectionStatus = classConnectivityCheck.WebServiceConnectivityCheck();
}
if (ConnectionStatus == "Success")
{
string savetime = System.DateTime.Now.ToString("dd-MMM-yyyy HH:mm:ss");
string state = details.InsertKPCTTruckTallySheetDetailsOracleNew(TAG, txtWidth.Text.ToString(), txtHight.Text.ToString(), txtCTotal.Text.ToString(), classLogin.User, savetime);
if (state == "SUCCESS")
{
classLog.writeLog("Message @: KPCT Operations Tally Sheet: Saved successfully in DB.");
AddDetailstoDataGrid();
txtWidth.Text = ""; txtHight.Text = ""; txtCTotal.Text = "";
}
else
{
lblStatus.Text = state.ToString();
classLog.writeLog("Error @: KPCT Operations-TallySheet Insert: SaveFailed.");
}
}
else
{
lblStatus.Text = " Webservice Not Connected..";
classLog.writeLog("Error @: KPCT Operations-TallySheet Wifi: Webservice Not Connected..");
}
}
else
{
lblStatus.Text = "Wifi Network Not Connected..";
classLog.writeLog("Error @: KPCT Operations-TallySheet: Wifi Network Not Connected..");
}
}
else if (classLogin.Connectivity == "GPRS")
{
string ConnectionStatus = classConnectivityCheck.WebServiceConnectivityCheck();
if (ConnectionStatus == "Failed")
{
ConnectionStatus = classConnectivityCheck.WebServiceConnectivityCheck();
}
if (ConnectionStatus == "Success")
{
KPCTSDS.WebReference_GPRS.Service1 details = new KPCTSDS.WebReference_GPRS.Service1();
string savetime = System.DateTime.Now.ToString("dd-MMM-yyyy HH:mm:ss");
string state = details.InsertKPCTTruckTallySheetDetailsOracleNew(TAG, txtWidth.Text.ToString(), txtHight.Text.ToString(), txtCTotal.Text.ToString(), classLogin.User, savetime);
if (state == "SUCCESS")
{
classLog.writeLog("Error @: KPCT Operations Tally Sheet: Saved successfully in DB.");
AddDetailstoDataGrid(); txtWidth.Text = ""; txtHight.Text = ""; txtCTotal.Text = "";
}
else
{
classLog.writeLog("Error @: KPCT Operations-TallySheet Insert: SaveFailed.");
}
}
else
{
lblStatus.Text = " Webservice Not Connected..";
classLog.writeLog("Error @: KPCT Operations-TallySheet GPRS: Webservice Not Connected..");
}
}
else
{
lblStatus.Text = "Network Not Connected..";
classLog.writeLog("Error @: KPCT Operations-TallySheet: Network Not Connected..");
}
}
}
public void savedetails()
{
btnDisable();
if (textBox1.Text == "" && textBox2.Text == "" && textBox3.Text == "" && textBox4.Text == "" && textBox5.Text == "" && textBox6.Text == "" && textBox7.Text == "" && textBox8.Text == "" && textBox9.Text == "")
{
lblStatus.Text = "Please Enter details.";
//MessageBox.Show("Please Enter details.");
}
else if (textBox1.Text == "0" && textBox2.Text == "0" && textBox3.Text == "0" && textBox4.Text == "0" && textBox5.Text == "0" && textBox6.Text == "0" && textBox7.Text == "0" && textBox8.Text == "0" && textBox9.Text == "0")
{
lblStatus.Text = "Please Enter details.";
//MessageBox.Show("Please Enter details.");
}
else
{
if (textBox1.Text == "")
{
textBox1.Text = "0";
}
if (textBox2.Text == "")
{
textBox2.Text = "0";
}
if (textBox3.Text == "")
{
textBox3.Text = "0";
}
if (textBox4.Text == "")
{
textBox4.Text = "0";
}
if (textBox5.Text == "")
{
textBox5.Text = "0";
}
if (textBox6.Text == "")
{
textBox6.Text = "0";
}
if (textBox7.Text == "")
{
textBox7.Text = "0";
}
if (textBox8.Text == "")
{
textBox8.Text = "0";
}
if (textBox9.Text == "")
{
textBox9.Text = "0";
}
if (classLogin.Connectivity == "WIFI")
{
KPCTSDS.appserver.Service1 details = new KPCTSDS.appserver.Service1();
string WifiConnectionStatus = classConnectivityCheck.WifiSignalStrenthCheck();
if (WifiConnectionStatus == "Success")
{
string ConnectionStatus = classConnectivityCheck.WebServiceConnectivityCheck();
if (ConnectionStatus == "Failed")
{
ConnectionStatus = classConnectivityCheck.WebServiceConnectivityCheck();
}
if (ConnectionStatus == "Success")
{
string savetime = System.DateTime.Now.ToString("dd-MMM-yyyy HH:mm:ss");
string state = details.InsertKPCTTruckTallySheetDetailsOracle(textBox1.Text.ToString(), textBox2.Text.ToString(), textBox3.Text.ToString(), textBox4.Text.ToString(), textBox5.Text.ToString(), textBox6.Text.ToString(), textBox7.Text.ToString(), textBox8.Text.ToString(), textBox9.Text.ToString(), TAG, classLogin.User, savetime);
if (state == "SUCCESS")
{
classLog.writeLog("Error @: KPCT Operations Tally Sheet: Saved successfully in DB.");
AddDetailstoDataGrid();
}
else
{
classLog.writeLog("Error @: KPCT Operations-TallySheet Insert: SaveFailed.");
}
}
else
{
lblStatus.Text = " Webservice Not Connected..";
classLog.writeLog("Error @: KPCT Operations-TallySheet Wifi: Webservice Not Connected..");
}
}
else
{
lblStatus.Text = "Wifi Network Not Connected..";
classLog.writeLog("Error @: KPCT Operations-TallySheet: Wifi Network Not Connected..");
}
}
else if (classLogin.Connectivity == "GPRS")
{
string ConnectionStatus = classConnectivityCheck.WebServiceConnectivityCheck();
if (ConnectionStatus == "Failed")
{
ConnectionStatus = classConnectivityCheck.WebServiceConnectivityCheck();
}
if (ConnectionStatus == "Success")
{
KPCTSDS.WebReference_GPRS.Service1 details = new KPCTSDS.WebReference_GPRS.Service1();
string savetime = System.DateTime.Now.ToString("dd-MMM-yyyy HH:mm:ss");
string state = details.InsertKPCTTruckTallySheetDetailsOracle(textBox1.Text.ToString(), textBox2.Text.ToString(), textBox3.Text.ToString(), textBox4.Text.ToString(), textBox5.Text.ToString(), textBox6.Text.ToString(), textBox7.Text.ToString(), textBox8.Text.ToString(), textBox9.Text.ToString(), TAG, classLogin.User, savetime);
if (state == "SUCCESS")
{
classLog.writeLog("Error @: KPCT Operations Tally Sheet: Saved successfully in DB.");
AddDetailstoDataGrid();
}
else
{
classLog.writeLog("Error @: KPCT Operations-TallySheet Insert: SaveFailed.");
}
}
else
{
lblStatus.Text = " Webservice Not Connected..";
classLog.writeLog("Error @: KPCT Operations-TallySheet GPRS: Webservice Not Connected..");
}
}
else
{
lblStatus.Text = "Network Not Connected..";
classLog.writeLog("Error @: KPCT Operations-TallySheet: Network Not Connected..");
}
}
btnEnable();
}
private void LoadTallySheetDetails()
{
DataSet ds = new DataSet();
if (classLogin.Connectivity == "WIFI")
{
KPCTSDS.appserver.Service1 details = new KPCTSDS.appserver.Service1();
if (classServerDetails.DBVarient == "Oracle")
{
ds = details.GetKPCTTruckTallySheetDetailsOracle(TAG);
}
}
else if (classLogin.Connectivity == "GPRS")
{
KPCTSDS.WebReference_GPRS.Service1 details = new KPCTSDS.WebReference_GPRS.Service1();
if (classServerDetails.DBVarient == "Oracle")
{
ds = details.GetKPCTTruckTallySheetDetailsOracle(TAG);
}
}
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
dt.Columns.Remove("TRUCKID");
workTable.Rows.Clear();
foreach (DataRow row in dt.Rows)
{
object[] o = { row["1"].ToString(), row["2"].ToString(), row["3"].ToString(), row["4"].ToString(), row["5"].ToString(), row["6"].ToString(), row["7"].ToString(), row["8"].ToString() };
workTable.Rows.Add(o);
}
}
dataGridTallySheet.DataSource = workTable;
////--Start-- Grid Style---
//dataGridTallySheet.TableStyles.Clear();
//DataGridTableStyle tableStyle = new DataGridTableStyle();
//tableStyle.MappingName = workTable.TableName;
//foreach (DataColumn item in workTable.Columns)
//{
// DataGridTextBoxColumn tbcName = new DataGridTextBoxColumn();
// tbcName.Width = 50;
// tbcName.MappingName = item.ColumnName;
// tbcName.HeaderText = item.ColumnName;
// tableStyle.GridColumnStyles.Add(tbcName);
//}
//dataGridTallySheet.TableStyles.Add(tableStyle);
////--End-- Grid Style---
//Display Total Qty and Status---Start---
int sum = 0;
for (int i = 1; i <= 8; i++)
{
foreach (DataRow dr in workTable.Rows)
{
sum += Convert.ToInt32(dr[i.ToString()]);
}
}
txtOpQty.Text = txtTotalQty1.Text = sum.ToString();
lblStatus1.Text = lblStatus.Text = workTable.Rows.Count.ToString() + " Rows Inserted.";
}