private bool LoadPortingValue()
{
var db = new DBEngine();
var dtPorting = new DataSet();
db.ExecuteQuery("Select IsStaticDynamic from ScreenCommon", null, dtPorting, "Porting");
if (dtPorting.Tables[0] != null && dtPorting.Tables[0].Rows.Count > 0 && !string.IsNullOrEmpty(dtPorting.Tables[0].Rows[0][0].ToString()))
{
if (!string.IsNullOrEmpty(dtPorting.Tables[0].Rows[0][0].ToString()))
{
return(Convert.ToBoolean(dtPorting.Tables[0].Rows[0][0].ToString()));
}
}
return(false);
}
private bool IsPortingSet()
{
var db = new DBEngine();
var dtPorting = new DataSet();
db.ExecuteQuery("Select Commtrack1, commBaud1 from ScreenCommon", null, dtPorting, "Porting");
if (dtPorting.Tables[0] != null && dtPorting.Tables[0].Rows.Count > 0 && !string.IsNullOrEmpty(dtPorting.Tables[0].Rows[0][0].ToString()) && !string.IsNullOrEmpty(dtPorting.Tables[0].Rows[0][1].ToString()))
{
return(true);
}
else
{
return(false);
}
}
private void StaticWeighment_Load(object sender, EventArgs e)
{
var db = new DBEngine();
var dtVendor = new DataSet();
lblTitle.Text = db.ExecuteQuery("Select Screen1,Commtrack1, commBaud1 from ScreenCommon");
txtDate.Text = DateTime.Now.ToString(Shared_Variables.DateFormat);
DataTable dt = GetDefaultData();
WagonType = dt.Rows[0][3].ToString();
From = dt.Rows[0][1].ToString();
To = dt.Rows[0][2].ToString();
Product = dt.Rows[0][0].ToString();
string tempTare = GetRakeNumberFromTempTare();
string tempGross = GetRakeNumberFromTempGross();
if (string.IsNullOrEmpty(tempTare) && string.IsNullOrEmpty(tempGross))
{
txtRakeNo.Text = DateTime.Now.Year + "000" + "001";
}
else
{
if (string.IsNullOrEmpty(tempTare))
{
tempTare = "0";
}
if (string.IsNullOrEmpty(tempGross))
{
tempGross = "0";
}
if (int.Parse(tempTare) > int.Parse(tempGross))
{
txtRakeNo.Text = tempTare.ToString();
}
else
{
txtRakeNo.Text = (int.Parse(tempGross) + 1).ToString();
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Do you want to Update all the records", "TareEntry", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
DataTable resultData = (DataTable)dgRakeView.DataSource;
string query = string.Format("Select ID,Slno,RakeNo,WagonNo,WagonType,Tare,Gross,dateout,timeout,spd,PCC,[From],[Product],[To],Net,UL,OL,CC from Temp where RakeNo={0} order by val(Slno)", txtRakeNo.Text);
var db = new DBEngine();
btnUpdate.Visible = false;
var dt = new System.Data.DataTable();
System.Data.OleDb.OleDbConnection cn = new System.Data.OleDb.OleDbConnection(db.ConnectionString);
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(query, cn);
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(cmd);
System.Data.OleDb.OleDbCommandBuilder ocb = new System.Data.OleDb.OleDbCommandBuilder(da);
//cn.Open();
da.Fill(dt);
ocb.QuoteSuffix = "]";
ocb.QuotePrefix = "[";
// var insertBuilder = new StringBuilder();
for (int i = 0; i < resultData.Rows.Count; i++)
{
//DataRow dr = dt.NewRow();
//dr["Slno"] = dttemp.Rows[i][0];
//dr["RakeNo"] = txtRakeNo.Text;
//dr["WagonType"] = txtWagonType.Text;
dt.Rows[i]["WagonNo"] = resultData.Rows[i][1];
dt.Rows[i]["Tare"] = resultData.Rows[i]["tare"];
dt.Rows[i]["Net"] = resultData.Rows[i]["net"];
//dt.Rows[i]["datein"] = resultData.Rows[i]["datein"];
//dt.Rows[i]["timein"] = resultData.Rows[i]["timein"];
dt.Rows[i]["UL"] = resultData.Rows[i]["UL"];
dt.Rows[i]["OL"] = resultData.Rows[i]["OL"];
dt.Rows[i]["CC"] = resultData.Rows[i]["CC"];
dt.Rows[i]["PCC"] = resultData.Rows[i]["PCC"];
}
da.Update(dt);
MessageBox.Show("Successfully Updated");
dgRakeView.DataSource = null;
txtRakeNo.Clear();
txtSlno.Clear();
}
}
private void txtRakeNo_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Enter)
{
if (!string.IsNullOrEmpty(txtRakeNo.Text))
{
string query = string.Format("Select slno,wagonno,wagontype,tare,pcc,cc,gross,net,UL,OL from temp where RakeNo={0} and Tare=0 order by val(slno)", txtRakeNo.Text);
var db = new DBEngine();
var dtVendor = new DataSet();
db.ExecuteQuery(query, null, dtVendor, "Rake");
dgRakeView.DataSource = dtVendor.Tables[0];
AssignDefaultValueForEmptyColumn();
//dgRakeView.Columns["datein"].Visible = false;
//dgRakeView.Columns["timein"].Visible = false;
txtWagonNo.Focus();
txtSlno.Text = "1";
}
}
}
private void txtPassword_KeyPress(object sender, KeyPressEventArgs e)
{
//update Login set Pwd='{0}' where LoginType='{1}' and UserName='******'
if (e.KeyChar == (char)Keys.Enter)
{
if (string.IsNullOrEmpty(txtPassword.Text))
{
return;
}
var dbengine = new DBEngine();
string pwd = dbengine.ExecuteQuery("select Pwd from Login where LoginType='Login' and UserName='******'");
if (txtUserName.Text == "RLYINMWB" && txtPassword.Text == pwd)
{
this.Hide();
new frmDefaultImage().Show();
}
else
{
MessageBox.Show("UserName And Password Is Incorrect");
return;
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Do you want to Save all the records", "TareEntry", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//string insertQuery = string.Empty;
//string updateQuery = string.Empty;
DataTable resultData = (DataTable)dgRakeView.DataSource;
//insertQuery = "insert into TempTare(Slno,RakeNo,WagonNo,WagonType,Tare,Gross,Net,PCC) values({0},'{1}','{2}','{3}','{4}','{5}','{6}','{7}')";
//updateQuery = "update TempGross Set WagonNo='{0}',Tare='{1}',Net='{2}' where Slno={3} and RakeNo={4}";
//foreach (DataRow dr in resultData.Rows)
//{
// string insertBuilder = string.Format(insertQuery, dr[0],txtRakeNo.Text,dr[1],dr[2],dr[3],dr[5],dr[6],dr[4]);
// var db = new DBEngine();
// db.ExecuteNonQuery(insertBuilder);
// insertBuilder = string.Format(updateQuery, dr[1], dr[4], dr[6], dr[0], txtRakeNo.Text);
// db.ExecuteNonQuery(insertBuilder);
//}
string query = string.Format("Select ID,Slno,RakeNo,WagonNo,WagonType,Tare,Gross,dateout,timeout,spd,PCC,[From],[Product],[To],Net,UL,OL,CC from Temp where RakeNo={0} order by val(Slno)", txtRakeNo.Text);
var db = new DBEngine();
btnSave.Visible = false;
var dt = new System.Data.DataTable();
System.Data.OleDb.OleDbConnection cn = new System.Data.OleDb.OleDbConnection(db.ConnectionString);
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(query, cn);
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(cmd);
System.Data.OleDb.OleDbCommandBuilder ocb = new System.Data.OleDb.OleDbCommandBuilder(da);
//cn.Open();
da.Fill(dt);
ocb.QuoteSuffix = "]";
ocb.QuotePrefix = "[";
// var insertBuilder = new StringBuilder();
for (int i = 0; i < resultData.Rows.Count; i++)
{
//DataRow dr = dt.NewRow();
//dr["Slno"] = dttemp.Rows[i][0];
//dr["RakeNo"] = txtRakeNo.Text;
//dr["WagonType"] = txtWagonType.Text;
dt.Rows[i]["WagonNo"] = resultData.Rows[i][1];
dt.Rows[i]["Tare"] = resultData.Rows[i]["tare"];
dt.Rows[i]["Net"] = resultData.Rows[i]["net"];
//dt.Rows[i]["datein"] = resultData.Rows[i]["datein"];
//dt.Rows[i]["timein"] = resultData.Rows[i]["timein"];
dt.Rows[i]["UL"] = resultData.Rows[i]["UL"];
dt.Rows[i]["OL"] = resultData.Rows[i]["OL"];
dt.Rows[i]["CC"] = resultData.Rows[i]["CC"];
dt.Rows[i]["PCC"] = resultData.Rows[i]["PCC"];
}
da.Update(dt);
MessageBox.Show("Successfully Updated");
dgRakeView.DataSource = null;
txtRakeNo.Clear();
txtSlno.Clear();
}
}
