public void Param(string searchtype, string searchvalue)
{
DataSet dsKey = GenericFunc.DataSetFromMSSQL(Connection, ("exec sp_r_GetTruckOverAll '" + searchtype + "'," + "'" + searchvalue + "'"));
//DataTableReader drKey = dsKey.Tables[1].CreateDataReader();
data = dsKey;
}
public void GetRepairMERemark(string pMechanicID, string pExpID)
{
string strSQL = "exec sp_Get_RepairMERemark" + " '" + SExpID + "', '" + pMechanicID + "'";
DataSet dsKey = GenericFunc.DataSetFromMSSQL(Connection, strSQL);
int results = dsKey.Tables[0].Rows.Count;
if (results > 0)
{
dgvRemark.DataSource = null;
if (this.dgvRemark.DataSource != null)
{
this.dgvRemark.DataSource = null;
}
else
{
this.dgvRemark.Rows.Clear();
}
foreach (DataRow row in dsKey.Tables[0].Rows)
{
dgvRemark.Rows.Add(row["RemarkID"].ToString()
, row["DateRemark"].ToString().Replace(" 12:00:00 AM", "")
, row["Remark"].ToString().Replace(" 12:00:00 AM", "")
);
}
}
}
public void Param(string SearchType, string SearchValue, string SearchMonth, string SearchYear)
{
DataSet dsKey = GenericFunc.DataSetFromMSSQL(Connection, ("exec sp_r_GetProjectSiteMonthly '" + SearchType + "'," + "'" + SearchValue + "'," + "'" + SearchMonth + "'," + "'" + SearchYear + "'"));
data = dsKey;
MonthYear = (SearchMonth == string.Empty ? " " : SearchMonth) + " " + (SearchYear == string.Empty ? " " : SearchYear);
}
public void Param(string SearchType, string SearchValue)
{
DataSet dsKey = GenericFunc.DataSetFromMSSQL(Connection, ("exec sp_r_GetProjectSiteOverAll '" + SearchType + "'," + "'" + SearchValue + "'"));
//DataTableReader drKey = dsKey.Tables[1].CreateDataReader();
data = dsKey;
//MonthYear = (SearchMonth == string.Empty ? " " : SearchMonth) + " " + (SearchYear == string.Empty ? " " : SearchYear);
}
public void Param(string ProjectId, string ProjectNo, string ProjectSite, string ProjectDate, string PMonth, string PYear)
{
DataSet dsKey = GenericFunc.DataSetFromMSSQL(Connection, ("exec sp_r_ProjectSiteM_Detail '" + ProjectId + "'," + "'" + ProjectNo + "'," + "'" + ProjectSite + "'," + "'" + ProjectDate + "'," + "'" + PMonth + "'," + "'" + PYear + "'"));
data = dsKey;
MonthYear = (PMonth == string.Empty ? " " : PMonth) + " " + (PYear == string.Empty ? " " : PYear);
p_ProjectId = ProjectNo;
p_ProjectSite = ProjectSite;
p_ProjectDate = ProjectDate;
}
public void Param(string pEquipmentNo, string pModel, string pPlateNo, string StartDate, string EndDate)
{
DataSet dsKey = GenericFunc.DataSetFromMSSQL(Connection, ("exec sp_Get_InfoAndMonitoring '" + pEquipmentNo + "'," + "'" + pModel + "'," + "'" + pPlateNo + "'," + "'" + StartDate + "'," + "'" + EndDate + "'"));
datavalue = dsKey;
EquipmentNo = pEquipmentNo;
Model = pModel;
PlateNo = pPlateNo;
TotalKm = dsKey.Tables[1].Rows[0]["Kms_Used"].ToString();
TotalHrs = dsKey.Tables[1].Rows[0]["Hrs_Used"].ToString();
DateParam = (StartDate == string.Empty ? " " : StartDate.Replace(" 12:00:00 AM", "")) + " To " + (EndDate == string.Empty ? " " : EndDate.Replace(" 12:00:00 AM", ""));
}
public void GetRepairME()
{
string result;
string strSQL = "exec sp_Get_RepairME" + " '" + SExpID + "'";
//reader = GenericFunc.ExecuteReader(spName, Userid, parmcurrentpass, parmnewpass, parmpIPAddress);
//DataTable data = new DataTable();
//DataTableReader readesr = GenericFunc.MSsqlDataReader(Connection, strSQL);
DataSet dsKey = GenericFunc.DataSetFromMSSQL(Connection, strSQL);
int results = dsKey.Tables[0].Rows.Count;
//if (readesr.Read())
//{
// result = readesr["Name"].ToString();
// //strUsrBranch = reader["Branch"].ToString();
//}
if (results > 0)
{
dgvMechanic.DataSource = null;
if (this.dgvMechanic.DataSource != null)
{
this.dgvMechanic.DataSource = null;
}
else
{
this.dgvMechanic.Rows.Clear();
}
foreach (DataRow row in dsKey.Tables[0].Rows)
{
dgvMechanic.Rows.Add(row["MechanicID"].ToString()
, row["IsComplete"].ToString()
, row["Name"].ToString()
);
}
}
}
public void Param(string pEquipmentNo, string pModel, string pPlateNo, DataTable DtUnitDetail, string userid)
{
CategoryParent();
FuelCategory();
string SEquipmentno = "'" + pEquipmentNo + "'";
string SModel = "'" + pModel + "'";
string SPlateno = "'" + pPlateNo + "'";
string spName = "sp_Get_TruckInfo";
//SqlDataReader reader;
//reader = monitoring.ExecuteReader(spName, SEquipmentno, SModel, SPlateno);
//result = DtUnitDetail;
//result.Load(reader);
userlogin = userid;
DataSet dsKey = GenericFunc.DataSetFromMSSQL(Connection, ("exec sp_Get_TruckInfo '" + pEquipmentNo + "'," + "'" + pModel + "'," + "'" + pPlateNo + "'"));
datavalue = dsKey;
//DataTableReader drKey = dsKey.Tables[0].CreateDataReader();
//// NumberofTable = result.Rows[0]["NumberofTable"].ToString();
//lblServiceId.Text = result.Rows[0]["ServiceID"].ToString();
//cmbfuel.Text = result.Rows[0]["FuelType"].ToString();
//txtPNModelName.Text = result.Rows[0]["PlateNo"].ToString();
//txtEngineNo.Text = result.Rows[0]["EngineNo"].ToString();
//txtChassisNo.Text = result.Rows[0]["ChassisNo"].ToString();
//txtPiston.Text = result.Rows[0]["PistonDisplacement"].ToString();
//txtCylinder.Text = result.Rows[0]["NoCylinder"].ToString();
//txtEqpName.Text = result.Rows[0]["Model"].ToString();
//cmbType.Text = result.Rows[0]["TruckType"].ToString();
//txtMake.Text = result.Rows[0]["Make"].ToString();
//txtSeries.Text = result.Rows[0]["Series"].ToString();
//txtBodyType.Text = result.Rows[0]["BodyType"].ToString();
//txtYearModel.Text = result.Rows[0]["YearModel"].ToString();
//txtGrossWT.Text = result.Rows[0]["GrossWt"].ToString();
//txtEqpNo.Text = result.Rows[0]["EquipmentNo"].ToString(); ;
//cmbPurchase.Text = result.Rows[0]["StatusOfPurchase"].ToString(); ;
//dtpPurchase.Text = result.Rows[0]["DateOfPurchase"].ToString(); ;
//txtCRNo.Text = result.Rows[0]["CR_No"].ToString(); ;
//txtSupplier.Text = result.Rows[0]["Supplier"].ToString(); ;
//txtExisting.Text = result.Rows[0]["ExistingReadingKm"].ToString(); ;
//txtMVFile.Text = result.Rows[0]["MVFile_No"].ToString(); ;
//cmbMonth.Text = result.Rows[0]["Month_R_Expired"].ToString();
//txtYear.Text = result.Rows[0]["Year_R_Expired"].ToString();
//txtUnitPrice.Text = result.Rows[0]["UnitPrice"].ToString();
//cmbType.Text = result.Rows[0]["Trucktype"].ToString();
//txtCurrentReading.Text = result.Rows[0]["CurrentReading"].ToString();
////string[] SRegiter = pRegister.Split(' ');
//CurrentReading = result.Rows[0]["CurrentReading"].ToString();
//Price = result.Rows[0]["UnitPrice"].ToString();
//TruckType = result.Rows[0]["Trucktype"].ToString();
//FuelType = result.Rows[0]["FuelType"].ToString();
//PlateNo = result.Rows[0]["PlateNo"].ToString();
//EngineNo = result.Rows[0]["EngineNo"].ToString();
//ChasisNo = result.Rows[0]["ChassisNo"].ToString();
//PistonDis = result.Rows[0]["PistonDisplacement"].ToString();
//NoCylinders = result.Rows[0]["NoCylinder"].ToString();
//Model = result.Rows[0]["Model"].ToString();
//Type = result.Rows[0]["TruckType"].ToString();
//Make = result.Rows[0]["Make"].ToString();
//Series = result.Rows[0]["Series"].ToString();
//BodyType = result.Rows[0]["BodyType"].ToString();
//YearModel = result.Rows[0]["YearModel"].ToString();
//GrossWt = result.Rows[0]["GrossWt"].ToString();
//EquipmentNo = result.Rows[0]["EquipmentNo"].ToString();
//StatusofPurchase = result.Rows[0]["StatusOfPurchase"].ToString();
//DateOfPurchase = result.Rows[0]["DateOfPurchase"].ToString();
//CRNo = result.Rows[0]["CR_No"].ToString();
//Supplier = result.Rows[0]["Supplier"].ToString();
//ExistingRead = result.Rows[0]["ExistingReadingKm"].ToString();
//MVFile = result.Rows[0]["MVFile_No"].ToString();
//Register = result.Rows[0]["Month_R_Expired"].ToString() + " " + result.Rows[0]["Year_R_Expired"].ToString();
////////////
// NumberofTable = dsKey.Tables[0].Rows[0]["NumberofTable"].ToString();
lblServiceId.Text = dsKey.Tables[0].Rows[0]["ServiceID"].ToString();
cmbfuel.Text = dsKey.Tables[0].Rows[0]["FuelType"].ToString();
txtPNModelName.Text = dsKey.Tables[0].Rows[0]["PlateNo"].ToString();
txtEngineNo.Text = dsKey.Tables[0].Rows[0]["EngineNo"].ToString();
txtChassisNo.Text = dsKey.Tables[0].Rows[0]["ChassisNo"].ToString();
txtPiston.Text = dsKey.Tables[0].Rows[0]["PistonDisplacement"].ToString();
txtCylinder.Text = dsKey.Tables[0].Rows[0]["NoCylinder"].ToString();
txtEqpName.Text = dsKey.Tables[0].Rows[0]["Model"].ToString();
cmbType.Text = dsKey.Tables[0].Rows[0]["TruckType"].ToString();
txtMake.Text = dsKey.Tables[0].Rows[0]["Make"].ToString();
txtSeries.Text = dsKey.Tables[0].Rows[0]["Series"].ToString();
txtBodyType.Text = dsKey.Tables[0].Rows[0]["BodyType"].ToString();
txtYearModel.Text = dsKey.Tables[0].Rows[0]["YearModel"].ToString();
txtGrossWT.Text = dsKey.Tables[0].Rows[0]["GrossWt"].ToString();
txtEqpNo.Text = dsKey.Tables[0].Rows[0]["EquipmentNo"].ToString();;
cmbPurchase.Text = dsKey.Tables[0].Rows[0]["StatusOfPurchase"].ToString();;
dtpPurchase.Text = dsKey.Tables[0].Rows[0]["DateOfPurchase"].ToString();;
txtCRNo.Text = dsKey.Tables[0].Rows[0]["CR_No"].ToString();;
txtSupplier.Text = dsKey.Tables[0].Rows[0]["Supplier"].ToString();;
txtExisting.Text = dsKey.Tables[0].Rows[0]["ExistingReadingKm"].ToString();;
txtMVFile.Text = dsKey.Tables[0].Rows[0]["MVFile_No"].ToString();;
cmbMonth.Text = dsKey.Tables[0].Rows[0]["Month_R_Expired"].ToString();
txtYear.Text = dsKey.Tables[0].Rows[0]["Year_R_Expired"].ToString();
txtUnitPrice.Text = dsKey.Tables[0].Rows[0]["UnitPrice"].ToString();
cmbType.Text = dsKey.Tables[0].Rows[0]["Trucktype"].ToString();
txtCurrentReading.Text = dsKey.Tables[0].Rows[0]["CurrentReading"].ToString();
txtHourlyRate.Text = dsKey.Tables[0].Rows[0]["HourlyRates"].ToString();
txtkmltr.Text = dsKey.Tables[0].Rows[0]["km_ltr"].ToString();
//string[] SRegiter = pRegister.Split(' ');
CurrentReading = dsKey.Tables[0].Rows[0]["CurrentReading"].ToString();
Price = dsKey.Tables[0].Rows[0]["UnitPrice"].ToString();
TruckType = dsKey.Tables[0].Rows[0]["Trucktype"].ToString();
FuelType = dsKey.Tables[0].Rows[0]["FuelType"].ToString();
PlateNo = dsKey.Tables[0].Rows[0]["PlateNo"].ToString();
EngineNo = dsKey.Tables[0].Rows[0]["EngineNo"].ToString();
ChasisNo = dsKey.Tables[0].Rows[0]["ChassisNo"].ToString();
PistonDis = dsKey.Tables[0].Rows[0]["PistonDisplacement"].ToString();
NoCylinders = dsKey.Tables[0].Rows[0]["NoCylinder"].ToString();
Model = dsKey.Tables[0].Rows[0]["Model"].ToString();
Type = dsKey.Tables[0].Rows[0]["TruckType"].ToString();
Make = dsKey.Tables[0].Rows[0]["Make"].ToString();
Series = dsKey.Tables[0].Rows[0]["Series"].ToString();
BodyType = dsKey.Tables[0].Rows[0]["BodyType"].ToString();
YearModel = dsKey.Tables[0].Rows[0]["YearModel"].ToString();
GrossWt = dsKey.Tables[0].Rows[0]["GrossWt"].ToString();
EquipmentNo = dsKey.Tables[0].Rows[0]["EquipmentNo"].ToString();
StatusofPurchase = dsKey.Tables[0].Rows[0]["StatusOfPurchase"].ToString();
DateOfPurchase = dsKey.Tables[0].Rows[0]["DateOfPurchase"].ToString();
CRNo = dsKey.Tables[0].Rows[0]["CR_No"].ToString();
Supplier = dsKey.Tables[0].Rows[0]["Supplier"].ToString();
ExistingRead = dsKey.Tables[0].Rows[0]["ExistingReadingKm"].ToString();
MVFile = dsKey.Tables[0].Rows[0]["MVFile_No"].ToString();
HourlyRate = dsKey.Tables[0].Rows[0]["HourlyRates"].ToString();
Register = dsKey.Tables[0].Rows[0]["Month_R_Expired"].ToString() + " " + dsKey.Tables[0].Rows[0]["Year_R_Expired"].ToString();
kmsltr = dsKey.Tables[0].Rows[0]["km_ltr"].ToString();
string CountTire = "";
string CountBattery = "";
CountTire = dsKey.Tables[1].Rows[0]["CountTire"].ToString();
CountBattery = dsKey.Tables[1].Rows[0]["CountBattery"].ToString();
dgvTire.DataSource = null;
if (this.dgvTire.DataSource != null)
{
this.dgvTire.DataSource = null;
}
else
{
this.dgvTire.Rows.Clear();
}
dgvBattery.DataSource = null;
if (this.dgvBattery.DataSource != null)
{
this.dgvBattery.DataSource = null;
}
else
{
this.dgvBattery.Rows.Clear();
}
if (CountBattery != "0")
{
foreach (DataRow row in dsKey.Tables[3].Rows)
{
dgvBattery.Rows.Add(row["BatteryID"].ToString()
, row["AllocationNo"].ToString()
, row["Item"].ToString()
, row["SerialNo"].ToString()
, row["PartsNo"].ToString()
);
}
}
if (CountTire != "0")
{
foreach (DataRow row in dsKey.Tables[2].Rows)
{
dgvTire.Rows.Add(row["TireID"].ToString()
, row["AllocationNo"].ToString()
, row["Item"].ToString()
, row["SerialNo"].ToString()
, row["PartsNo"].ToString()
);
}
}
///////
/*
* cmbfuel.Text = pFuelType;
* txtPNModelName.Text = pPlateNo;
* txtEngineNo.Text = pEngineNo;
* txtChassisNo.Text = pChasisNo;
* txtPiston.Text = pPistonDis;
* txtCylinder.Text = pNoCylinders;
* txtEqpName.Text = pModel;
* cmbType.Text = pType;
* txtMake.Text = pMake;
* txtSeries.Text = pSeries;
* txtBodyType.Text = pBodyType;
* txtYearModel.Text = pYearModel;
* txtGrossWT.Text = pGrossWt;
* txtEqpNo.Text = pEquipmentNo;
* cmbPurchase.Text = pStatusofPurchase;
* dtpPurchase.Text = pDateOfPurchase;
* txtCRNo.Text = pCRNo;
* txtSupplier.Text = pSupplier;
* txtExisting.Text = pExistingRead;
* txtMVFile.Text = pMVFile;
* cmbMonth.Text = SRegiter[0];
* txtYear.Text = SRegiter[1];
* //Year = pYear;
* ///
* FuelType = pFuelType;
* PlateNo = pPlateNo;
* EngineNo = pEngineNo;
* ChasisNo = pChasisNo;
* PistonDis = pPistonDis;
* NoCylinders = pNoCylinders;
* Model = pModel;
* Type = pType;
* Make = pMake;
* Series = pSeries;
* BodyType = pBodyType;
* YearModel = pYearModel;
* GrossWt = pGrossWt;
* EquipmentNo = pEquipmentNo;
* StatusofPurchase = pStatusofPurchase;
* DateOfPurchase = pDateOfPurchase;
* CRNo = pCRNo;
* Supplier = pSupplier;
* ExistingRead = pExistingRead;
* MVFile = pMVFile;
* Register = pRegister;
*/
}
public void Param(string pExpID, string pUserId, DataTable CategoryAll, string pServiceID, string pDate)
{
IsCancel = "1";
SExpID = pExpID;
SUserID = pUserId;
SServiceID = pServiceID;
SDate = pDate;
dgvcmdCategory.HeaderText = "CATEGORY";
dgvcmdCategory.Name = "category";
ArrayList categoryL = new ArrayList();
foreach (DataRow dr in CategoryAll.Rows)
{
categoryL.Add(dr["Sub-Category"].ToString());
}
dgvcmdCategory.Items.AddRange(categoryL.ToArray());
dgvItem.Columns.Add(dgvcmdCategory);
dgvItem.Columns[14].Width = 177;
DataSet dsKey = GenericFunc.DataSetFromMSSQL(Connection, ("exec sp_Get_RepairAndMaintenanceItem '" + SExpID + "'"));
int vw_ItemExpenses = dsKey.Tables[0].Rows.Count;
dgvItem.DataSource = null;
if (this.dgvItem.DataSource != null)
{
this.dgvItem.DataSource = null;
}
else
{
this.dgvItem.Rows.Clear();
}
if (vw_ItemExpenses > 0)
{
foreach (DataRow row in dsKey.Tables[0].Rows)
{
dgvItem.Rows.Add(row["SourceID"].ToString()
// , "false"
, row["Qty"].ToString()
, row["Item"].ToString()
, row["IsPurchase"].ToString()
, String.Format("{0:#,###.00}", Convert.ToDecimal(row["PMS"])) //row["PMS"].ToString()
, String.Format("{0:#,###.00}", Convert.ToDecimal(row["Repair"])) //row["Repair"].ToString()
, String.Format("{0:#,###.00}", Convert.ToDecimal(row["Tire"])) //row["Tire"].ToString()
, row["PartsNo"].ToString()
, row["SerialNo"].ToString()
, row["ReferenceNo"].ToString()
, row["AllocationNo"].ToString()
, row["DateOfPurchase"].ToString().Replace(" 12:00:00 AM", "")
, row["DateCompleted"].ToString().Replace(" 12:00:00 AM", "")
// , row["Category"].ToString()
, row["Source"].ToString()
, row["SubCategory"].ToString()
// , row["Approval"].ToString()
);
}
}
}
private void btnOK_Click(object sender, EventArgs e)
{
string Value = "";
string Number = " ";
string NumberofTable = " ";
string EquipmentNo = " ";
string EquipmentName = " ";
string NumberName = " ";
string Truckid = " ";
string IsMaintenance = " ";
string TotalUsed = " ";
string Trucktype = " ";
string main = "";
//Enter Equipment No Or Plate No./Model Name
/*
* if (rdEqpNo.Checked)
* {
* Value = "EquipmentNo";
* }
* else
* {
* Value = "ModelName";
* }
*/
Value = "EquipmentNo";
Number = txtEnternumber.Text;
if (Number == " " || Number == "" || Number == null)
{
MessageBox.Show("Please Enter Equipment No Or Plate No./Model Name");
}
else
{
DialogResult dialogResult = MessageBox.Show("Please Click Yes to Continue", "Search", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
DataSet dsKey = GenericFunc.DataSetFromMSSQL(Connection, ("exec sp_Get_InfoAndMonitoring '" + Value + "'," + "'" + Number + "'"));
DataTableReader drKey = dsKey.Tables[0].CreateDataReader();
if (drKey.Read())
{
NumberofTable = dsKey.Tables[0].Rows[0]["NumberofTable"].ToString();
main = dsKey.Tables[0].Rows[0]["maintable"].ToString();
if (NumberofTable == "0")
{
MessageBox.Show("Record Not Found. Please check Equipment No Or Plate No./Model Name.");
}
else
{
if (main != "0")
{
IsMaintenance = dsKey.Tables[1].Rows[0]["IsMaintenance"].ToString();
TotalUsed = dsKey.Tables[1].Rows[0]["TotalUsed"].ToString();
EquipmentNo = dsKey.Tables[2].Rows[0]["EquipmentNo"].ToString();
EquipmentName = dsKey.Tables[2].Rows[0]["Model"].ToString();
NumberName = dsKey.Tables[2].Rows[0]["PlateNo"].ToString();
Truckid = dsKey.Tables[2].Rows[0]["TruckId"].ToString();
Trucktype = dsKey.Tables[2].Rows[0]["Trucktype"].ToString();
AddMonitoring monitoring = new AddMonitoring();
monitoring.Param(EquipmentNo, EquipmentName, NumberName, Truckid, dsKey.Tables[3], NumberofTable, Value, TotalUsed, IsMaintenance, formtype, Trucktype);
this.Hide();
monitoring.ShowDialog(this);
this.Close();
}
else
{
MessageBox.Show("Record Not Found. Please check Equipment No Or Plate No./Model Name.");
}
}
}
else
{
}
}
}
}