public void GetJOBCardInfoByID(int ID) { transportdata = new TransportData(); DS = transportdata.GetJOBCardInfoByID(ID); ClearTextBox(); lblShowMessage.Text = string.Empty; if (!Comman.Comman.IsDataSetEmpty(DS)) { txtOutKM.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["StartKm"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["StartKm"].ToString(); txtInKM.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["EndKm"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["EndKm"].ToString(); txtVOpId.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["VOp"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["VOp"].ToString(); txtInDate.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["EndDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["EndDate"].ToString(); txtOutDate.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["StartDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["StartDate"].ToString(); txtOutTime.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["StartTime"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["StartTime"].ToString(); txtInTime.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["EndTime"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["EndTime"].ToString(); txtSalesMan.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Salesman"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Salesman"].ToString(); txtDriver.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Driver"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Driver"].ToString(); txtRunKM.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TotalKm"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["TotalKm"].ToString(); txtDieselLtr.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["FuelLtr"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["FuelLtr"].ToString(); txtAmt.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["FuelAmount"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["FuelAmount"].ToString(); txtRouteId.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TransportRoute"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["TransportRoute"].ToString(); } if (Comman.Comman.IsDataSetEmpty(DS)) { lblShowMessage.Text = "Operation Not Completed yet "; } }