private void bttReadAll_Click(object sender, EventArgs e)
{
DataTable AllRows = ((DataTable)gridControlPhone.DataSource);
DataRow currentRow;
DataTable RecordHaveMore = new DataTable();
DataTable RecordPhone = new DataTable();
string startDate = "";
string startTime = "";
string endDate = "";
string endTime = "";
DateTime startDateTime = new DateTime();
DateTime endDateTime = new DateTime();
string phoneNo = "";
DataTable PhoneRecord = new DataTable();
adcHelper PhoneDT = new adcHelper();
double Amount_total = 0;
for (int k = 0; k < AllRows.Rows.Count; k++)
{
// Read Button
currentRow = gridViewPhone.GetDataRow(k);
startDate = ((DateTime)currentRow["start_date"]).ToString("dd/MM/yyyy");
startTime = currentRow["start_time"].ToString().Substring(0, 8);
endDate = ((DateTime)currentRow["end_date"]).ToString("dd/MM/yyyy");
endTime = currentRow["end_time"].ToString().Substring(0, 8);
startDateTime = ConvertStringToDate(startDate + " " + startTime, "dd/MM/yyyy HH:mm:ss");
endDateTime = ConvertStringToDate(endDate + " " + endTime, "dd/MM/yyyy HH:mm:ss");
phoneNo = currentRow["phone_label"].ToString();
Amount_total = 0;
// Check Data Existing in biiling database
RecordHaveMore = BusinessLogicBridge.DataStore.CheckPhoneTransByDateTime(((DateTime)currentRow["end_date"]).ToString("yyyy-MM-dd"), endTime, phoneNo);
for (int i = 0; i < RecordHaveMore.Rows.Count; i++)
{
Amount_total += RecordHaveMore.Rows[i]["Amount"].To <double>();
}
gridViewPhone.SetRowCellValue(k, "amount_text", Amount_total.ToString("N2"));
gridViewPhone.SetRowCellValue(k, "amount", Amount_total);
}
//if (FlagsConnect == false)
//{
// utilClass.showPopupMessegeBox(this, getLanguage("_msg_1083"), getLanguage("_softwarename"));
// return;
//}
}
private void bttReadAll_Click(object sender, EventArgs e)
{
DataTable AllRow = ((DataTable)gridControlWMeter.DataSource);
#region Meter in room
DataRow currentRow;
DataTable ERecord = new DataTable();
adcHelper EmeterDT = new adcHelper();
string connection_text = "";
int result = DateTime.Compare(dateEditRecord.EditValue.To<DateTime>().Date, DateTime.Now.Date);
// pd date < dateEditRecord.EditValue
if (result == 0)
{
ERecord = BusinessLogicBridge.DataStore.ReadWmeterPresentAll(lookUpEditBuilding.EditValue.To<int>());
int ErowCount = ERecord.Rows.Count;
for (int k = 0; k < ErowCount; k++)
{
if (ErowCount > 0 && ERecord.Rows[k]["wpresent_date_update"].ToString() != "")
{
if (ERecord.Rows[0]["water_status"].To<int>() == 0)
{
// failed
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_date_update", ERecord.Rows[0]["wpresent_date_update"]);
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_energy_value", ERecord.Rows[0]["wpresent_energy_value"]);
gridViewWMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Fail";
}
else
{
// pass
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_date_update", ERecord.Rows[0]["wpresent_date_update"]);
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_energy_value", ERecord.Rows[0]["wpresent_energy_value"]);
gridViewWMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Pass";
}
}
else
{
connection_text = "";
// failed
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_date_update", DateTime.Today);
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_energy_value", 0.00);
gridViewWMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Fail";
}
gridViewWMeterInRoom.SetRowCellValue(k, "E_CommStatus", connection_text);
}
}
else
{
for (int k = 0; k < AllRow.Rows.Count; k++)
{
currentRow = gridViewWMeterInRoom.GetDataRow(k);
ERecord = BusinessLogicBridge.DataStore.ReadWaterRecordingByMeterAndDate(currentRow["water_id"].To<int>(), dateEditRecord.EditValue.To<DateTime>());
if (ERecord.Rows.Count > 0 && ERecord.Rows[0]["DateLastest"].ToString() != "")
{
if (ERecord.Rows[0]["w_connection"].To<int>() == 0)
{
// failed
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_date_update", ERecord.Rows[0]["DateLastest"]);
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_energy_value", ERecord.Rows[0]["w_unit"]);
gridViewWMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Fail";
}
else
{
// pass
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_date_update", ERecord.Rows[0]["DateLastest"]);
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_energy_value", ERecord.Rows[0]["w_unit"]);
gridViewWMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Pass";
}
}
else
{
connection_text = "";
// failed
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_date_update", dateEditRecord.EditValue.To<DateTime>());
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_energy_value", 0.00);
gridViewWMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Fail";
}
gridViewWMeterInRoom.SetRowCellValue(k, "E_CommStatus", connection_text);
}
}
#endregion
//if (adc_connected == false)
//{
// utilClass.showPopupMessegeBox(this, getLanguage("_msg_1053"), getLanguage("_softwarename"));
//}
}
private void bttReadAll_Click(object sender, EventArgs e)
{
DataTable AllRow = ((DataTable)gridControlMeterInRoom.DataSource);
DataTable AllRowUtility = ((DataTable)gridControlMeterUtility.DataSource);
#region Meter in room
DataRow currentRow;
DataTable ERecord = new DataTable();
adcHelper EmeterDT = new adcHelper();
string connection_text = "";
bool adc_connected = true;
int result = DateTime.Compare(dateEditRecord.EditValue.To<DateTime>().Date,DateTime.Now.Date);
// pd date == dateEditRecord.EditValue
if (result == 0)
{
ERecord = BusinessLogicBridge.DataStore.ReadEmeterPresentAll(lookUpEditBuilding.EditValue.To<int>());
int ErowCount = ERecord.Rows.Count;
for (int k = 0; k < ErowCount; k++)
{
if (ErowCount > 0 && ERecord.Rows[k]["present_date_update"].ToString() != "")
{
if (ERecord.Rows[k]["meter_status"].To<int>() == 0)
{
// failed
gridViewMeterInRoom.SetRowCellValue(k, "present_date_update", ERecord.Rows[k]["present_date_update"]);
gridViewMeterInRoom.SetRowCellValue(k, "present_energy_value", ERecord.Rows[k]["present_energy_value"]);
gridViewMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Fail";
}
else
{
// pass
gridViewMeterInRoom.SetRowCellValue(k, "present_date_update", ERecord.Rows[k]["present_date_update"]);
gridViewMeterInRoom.SetRowCellValue(k, "present_energy_value", ERecord.Rows[k]["present_energy_value"]);
gridViewMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Pass";
}
}
else
{
connection_text = "";
// failed
gridViewMeterInRoom.SetRowCellValue(k, "present_date_update", DateTime.Today);
gridViewMeterInRoom.SetRowCellValue(k, "present_energy_value", 0.00);
gridViewMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Fail";
}
gridViewMeterInRoom.SetRowCellValue(k, "E_CommStatus", connection_text);
}
}
else {
for (int k = 0; k < AllRow.Rows.Count; k++)
{
currentRow = gridViewMeterInRoom.GetDataRow(k);
ERecord = BusinessLogicBridge.DataStore.ReadRecordingByMeterAndDate(currentRow["meter_id"].To<int>(), dateEditRecord.EditValue.To<DateTime>());
if (ERecord.Rows.Count > 0 && ERecord.Rows[0]["DateLastest"].ToString() != "")
{
if (ERecord.Rows[0]["e_connection"].To<int>() == 0)
{
// failed
gridViewMeterInRoom.SetRowCellValue(k, "present_date_update", ERecord.Rows[0]["DateLastest"]);
gridViewMeterInRoom.SetRowCellValue(k, "present_energy_value", ERecord.Rows[0]["TotalUnit"]);
gridViewMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Fail";
}
else
{
// pass
gridViewMeterInRoom.SetRowCellValue(k, "present_date_update", ERecord.Rows[0]["DateLastest"]);
gridViewMeterInRoom.SetRowCellValue(k, "present_energy_value", ERecord.Rows[0]["TotalUnit"]);
gridViewMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Pass";
}
}
else
{
connection_text = "";
// failed
gridViewMeterInRoom.SetRowCellValue(k, "present_date_update", dateEditRecord.EditValue.To<DateTime>());
gridViewMeterInRoom.SetRowCellValue(k, "present_energy_value", 0.00);
gridViewMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Fail";
}
gridViewMeterInRoom.SetRowCellValue(k, "E_CommStatus", connection_text);
}
}
#endregion
#region Meter Utility
DataRow currentRowUtility;
DataTable ERecordUtility = new DataTable();
adcHelper EmeterDTUtility = new adcHelper();
string connection_textUtility = "";
int resultUtility = DateTime.Compare(dateEditRecord.EditValue.To<DateTime>().Date, DateTime.Now.Date);
if (resultUtility == 0)
{
ERecordUtility = BusinessLogicBridge.DataStore.ReadEmeterUtilityPresentAll(lookUpEditBuilding.EditValue.To<int>());
int ErowCount = ERecordUtility.Rows.Count;
for (int k = 0; k < ErowCount; k++)
{
if (ErowCount > 0 && ERecordUtility.Rows[k]["present_date_update"].ToString() != "")
{
if (ERecordUtility.Rows[k]["meter_status"].To<int>() == 0)
{
// failed
gridViewMeterUtility.SetRowCellValue(k, "present_date_update", ERecordUtility.Rows[k]["present_date_update"]);
gridViewMeterUtility.SetRowCellValue(k, "present_energy_value", ERecordUtility.Rows[k]["present_energy_value"]);
gridViewMeterUtility.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_textUtility = "Fail";
}
else
{
// pass
gridViewMeterUtility.SetRowCellValue(k, "present_date_update", ERecordUtility.Rows[k]["present_date_update"]);
gridViewMeterUtility.SetRowCellValue(k, "present_energy_value", ERecordUtility.Rows[k]["present_energy_value"]);
gridViewMeterUtility.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_textUtility = "Pass";
}
}
else
{
connection_textUtility = "";
// failed
gridViewMeterUtility.SetRowCellValue(k, "present_date_update", DateTime.Today);
gridViewMeterUtility.SetRowCellValue(k, "present_energy_value", 0.00);
gridViewMeterUtility.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_textUtility = "Fail";
}
gridViewMeterUtility.SetRowCellValue(k, "E_CommStatus", connection_textUtility);
}
}
else
{
for (int k = 0; k < AllRowUtility.Rows.Count; k++)
{
currentRowUtility = gridViewMeterUtility.GetDataRow(k);
ERecordUtility = BusinessLogicBridge.DataStore.ReadRecordingByMeterAndDate(currentRowUtility["meter_id"].To<int>(), dateEditRecord.EditValue.To<DateTime>());
if (ERecordUtility.Rows.Count > 0 && ERecordUtility.Rows[0]["DateLastest"].ToString() != "")
{
if (ERecordUtility.Rows[0]["e_connection"].To<int>() == 0)
{
// failed
gridViewMeterUtility.SetRowCellValue(k, "present_date_update", ERecordUtility.Rows[0]["DateLastest"]);
gridViewMeterUtility.SetRowCellValue(k, "present_energy_value", ERecordUtility.Rows[0]["TotalUnit"]);
gridViewMeterUtility.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_textUtility = "Fail";
}
else
{
// pass
gridViewMeterUtility.SetRowCellValue(k, "present_date_update", ERecordUtility.Rows[0]["DateLastest"]);
gridViewMeterUtility.SetRowCellValue(k, "present_energy_value", ERecordUtility.Rows[0]["TotalUnit"]);
gridViewMeterUtility.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_textUtility = "Pass";
}
}
else
{
connection_textUtility = "";
// failed
gridViewMeterUtility.SetRowCellValue(k, "present_date_update", dateEditRecord.EditValue.To<DateTime>());
gridViewMeterUtility.SetRowCellValue(k, "present_energy_value", 0.00);
gridViewMeterUtility.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_textUtility = "Fail";
}
gridViewMeterUtility.SetRowCellValue(k, "E_CommStatus", connection_textUtility);
}
}
#endregion
}
private void bttReadAll_Click(object sender, EventArgs e)
{
DataTable AllRows = ((DataTable)gridControlPhone.DataSource);
DataRow currentRow;
DataTable RecordHaveMore = new DataTable();
DataTable RecordPhone = new DataTable();
string startDate = "";
string startTime = "";
string endDate = "";
string endTime = "";
DateTime startDateTime = new DateTime();
DateTime endDateTime = new DateTime();
string phoneNo = "";
DataTable PhoneRecord = new DataTable();
adcHelper PhoneDT = new adcHelper();
double Amount_total = 0;
for (int k = 0; k < AllRows.Rows.Count; k++)
{
// Read Button
currentRow = gridViewPhone.GetDataRow(k);
startDate = ((DateTime)currentRow["start_date"]).ToString("dd/MM/yyyy");
startTime = currentRow["start_time"].ToString().Substring(0, 8);
endDate = ((DateTime)currentRow["end_date"]).ToString("dd/MM/yyyy");
endTime = currentRow["end_time"].ToString().Substring(0, 8);
startDateTime = ConvertStringToDate(startDate + " " + startTime, "dd/MM/yyyy HH:mm:ss");
endDateTime = ConvertStringToDate(endDate + " " + endTime, "dd/MM/yyyy HH:mm:ss");
phoneNo = currentRow["phone_label"].ToString();
Amount_total = 0;
// Check Data Existing in biiling database
RecordHaveMore = BusinessLogicBridge.DataStore.CheckPhoneTransByDateTime(((DateTime)currentRow["end_date"]).ToString("yyyy-MM-dd"), endTime, phoneNo);
for (int i = 0; i < RecordHaveMore.Rows.Count; i++)
{
Amount_total += RecordHaveMore.Rows[i]["Amount"].To<double>();
}
gridViewPhone.SetRowCellValue(k, "amount_text", Amount_total.ToString("N2"));
gridViewPhone.SetRowCellValue(k, "amount", Amount_total);
}
//if (FlagsConnect == false)
//{
// utilClass.showPopupMessegeBox(this, getLanguage("_msg_1083"), getLanguage("_softwarename"));
// return;
//}
}
private void bttReadAll_Click(object sender, EventArgs e)
{
DataTable AllRow = ((DataTable)gridControlWMeter.DataSource);
#region Meter in room
DataRow currentRow;
DataTable ERecord = new DataTable();
adcHelper EmeterDT = new adcHelper();
string connection_text = "";
int result = DateTime.Compare(dateEditRecord.EditValue.To <DateTime>().Date, DateTime.Now.Date);
// pd date < dateEditRecord.EditValue
if (result == 0)
{
ERecord = BusinessLogicBridge.DataStore.ReadWmeterPresentAll(lookUpEditBuilding.EditValue.To <int>());
int ErowCount = ERecord.Rows.Count;
for (int k = 0; k < ErowCount; k++)
{
if (ErowCount > 0 && ERecord.Rows[k]["wpresent_date_update"].ToString() != "")
{
if (ERecord.Rows[0]["water_status"].To <int>() == 0)
{
// failed
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_date_update", ERecord.Rows[0]["wpresent_date_update"]);
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_energy_value", ERecord.Rows[0]["wpresent_energy_value"]);
gridViewWMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Fail";
}
else
{
// pass
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_date_update", ERecord.Rows[0]["wpresent_date_update"]);
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_energy_value", ERecord.Rows[0]["wpresent_energy_value"]);
gridViewWMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Pass";
}
}
else
{
connection_text = "";
// failed
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_date_update", DateTime.Today);
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_energy_value", 0.00);
gridViewWMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Fail";
}
gridViewWMeterInRoom.SetRowCellValue(k, "E_CommStatus", connection_text);
}
}
else
{
for (int k = 0; k < AllRow.Rows.Count; k++)
{
currentRow = gridViewWMeterInRoom.GetDataRow(k);
ERecord = BusinessLogicBridge.DataStore.ReadWaterRecordingByMeterAndDate(currentRow["water_id"].To <int>(), dateEditRecord.EditValue.To <DateTime>());
if (ERecord.Rows.Count > 0 && ERecord.Rows[0]["DateLastest"].ToString() != "")
{
if (ERecord.Rows[0]["w_connection"].To <int>() == 0)
{
// failed
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_date_update", ERecord.Rows[0]["DateLastest"]);
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_energy_value", ERecord.Rows[0]["w_unit"]);
gridViewWMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Fail";
}
else
{
// pass
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_date_update", ERecord.Rows[0]["DateLastest"]);
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_energy_value", ERecord.Rows[0]["w_unit"]);
gridViewWMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Pass";
}
}
else
{
connection_text = "";
// failed
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_date_update", dateEditRecord.EditValue.To <DateTime>());
gridViewWMeterInRoom.SetRowCellValue(k, "wpresent_energy_value", 0.00);
gridViewWMeterInRoom.SetRowCellValue(k, "meter_read_date", DateTime.Today);
connection_text = "Fail";
}
gridViewWMeterInRoom.SetRowCellValue(k, "E_CommStatus", connection_text);
}
}
#endregion
//if (adc_connected == false)
//{
// utilClass.showPopupMessegeBox(this, getLanguage("_msg_1053"), getLanguage("_softwarename"));
//}
}
