//showing last record in Access DB
private void button9_Click(object sender, EventArgs e)
{
if (Rs.EOF == true && Rs.BOF == true)
{
MessageBox.Show("Table is Empty!");
return;
}
Rs.MoveLast();
MoveObj();
ShowDataOnForm();
}
//showing next record in db
private void button8_Click(object sender, EventArgs e)
{
if (Rs.EOF == true && Rs.BOF == true)
{
MessageBox.Show("Table is Empty!");
return;
}
Rs.MoveNext();
if (Rs.EOF == true)
{
Rs.MoveLast();
MessageBox.Show("Passed End of File");
}
ShowDataOnForm();
}
private void custmreceipt_Load(object sender, EventArgs e)
{
textBox1.Enabled = false;
textBox2.Enabled = false;
textBox4.Text = "0";
textBox3.Text = "0";
// comboBox2.DropDownStyle = ComboBoxStyle.DropDownList;
comboBox2.Properties.Items.Add("CASH");
comboBox2.Properties.Items.Add("CHEQUE");
// comboBox1.Properties.DropDownStyle = ComboBoxStyle.DropDownList;
label7.Visible = false;
textBox5.Visible = false;
Temp1.Open(@"select * from customerdetails", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic);
while (Temp1.EOF == false)
{
comboBox1.Properties.Items.Add(Temp1.Fields["CName"].Value);
Temp1.MoveNext();
}
Temp1.Close();
Temp1.Open(@"select * from payments", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic);
if (Temp1.RecordCount == 0)
{
textBox1.Text = "1";
}
else
{
Temp1.MoveLast();
int a = Temp1.Fields["payID"].Value + 1;
textBox1.Text = a.ToString();
Temp1.MoveNext();
}
Temp1.Close();
}
private void addcust_Click(object sender, EventArgs e)
{
if (addcust.Text == "&Add new Customer")
{
LockUnLockMe(false);
textBox1.ReadOnly = false;
int newid;
if (cstmr_tb.RecordCount > 0)
{
if (cpos != cstmr_tb.RecordCount)
{
cstmr_tb.MoveLast();
cpos = cstmr_tb.RecordCount;
}
newid = cstmr_tb.Fields["cID"].Value + 1;
}
else
{
newid = 1;
// textid.Text = (newid).ToString();
prev.Enabled = true;
}
emptyTxt();
textid.Text = newid.ToString();
addcust.Text = "&SAVE DETAILS";
fnd.Text = "&Cancel";
prev.Enabled = false;
nxt.Enabled = false;
edt.Enabled = false;
return;
}
if (addcust.Text == "&SAVE DETAILS")
{
if (textname.Text == "")
{
XtraMessageBox.Show("Invaild Name");
return;
}
cstmr_tb.AddNew();
GetData();
cstmr_tb.Update();
SetButton();
customers_list.Items.Add(textname.Text);
customers_list.Update();
cpos = cstmr_tb.RecordCount;
LockUnLockMe(true);
textBox1.ReadOnly = true;
}
}
private void addcust_Click(object sender, EventArgs e)
{
if (addcust.Text == "&Add new Farmer")
{
LockUnLockMe(false);
int newid;
if (frmr_tb.RecordCount > 0)
{
if (cpos != frmr_tb.RecordCount)
{
frmr_tb.MoveLast();
cpos = frmr_tb.RecordCount;
}
newid = frmr_tb.Fields["fID"].Value + 1;
}
else
{
newid = 1;
// textid.Text = (newid).ToString();
prev.Enabled = true;
}
emptyTxt();
textid.Text = newid.ToString();
addcust.Text = "&Save Details";
fnd.Text = "&Cancel";
prev.Enabled = false;
nxt.Enabled = false;
edt.Enabled = false;
return;
}
if (addcust.Text == "&Save Details")
{
if (textname.Text == "")
{
XtraMessageBox.Show("Invaild Name");
return;
}
frmr_tb.AddNew();
GetData();
frmr_tb.Update();
SetButton();
farmers_list.Items.Add(textname.Text);
farmers_list.Update();
cpos = frmr_tb.RecordCount;
}
}
private void goLast_Click(object sender, EventArgs e)
{
Rscar.MoveLast();
Show();
}
private void cmdAdd_Click(System.Object eventSender, System.EventArgs eventArgs)
{
int lID = 0;
ADODB.Recordset rs = default(ADODB.Recordset);
if (mbAddNewFlagID == true)
{
if (string.IsNullOrEmpty(txtFields[0].Text))
{
Interaction.MsgBox("Deal name is invalid.");
txtFields[0].Focus();
return;
}
System.Windows.Forms.Application.DoEvents();
if (update_Renamed())
{
p_Prom = adoPrimaryRS.Fields("PromotionID").Value;
if (chkFields[1].CheckState == 0)
{
modRecordSet.cnnDB.Execute("UPDATE GRVPromotion SET Promotion_StartDate = #" + DTFields[0].Value + "#, Promotion_EndDate = #" + DTFields[1].Value + "#, Promotion_StartTime = #" + DTFields[2].Value + "# ,Promotion_EndTime =#" + DTFields[3].Value + "# WHERE PromotionID = " + p_Prom + ";");
}
}
else
{
return;
}
}
lID = My.MyProject.Forms.frmStockList.getItem();
string[,] DateArr = null;
System.DateTime xDate = default(System.DateTime);
System.DateTime yDate = default(System.DateTime);
short xInt = 0;
if (lID != 0)
{
// ERROR: Not supported in C#: OnErrorStatement
xInt = (DateAndTime.DateDiff(Microsoft.VisualBasic.DateInterval.Day, _DTFields_0.Value, _DTFields_1.Value) == 0 ? 1 : DateAndTime.DateDiff(Microsoft.VisualBasic.DateInterval.Day, _DTFields_0.Value, _DTFields_1.Value));
DateArr = new string[xInt + 1, 2];
xInt = 0;
//For xDate = _DTFields_0.Value.Date To _DTFields_1.Value.Date
while (_DTFields_0.Value.Date < _DTFields_1.Value.Date)
{
if (xDate == _DTFields_0.Value)
{
DateArr[xInt, 0] = Convert.ToString(xDate);
DateArr[xInt, 1] = "S";
}
else if (xDate == _DTFields_1.Value)
{
DateArr[xInt, 0] = Convert.ToString(xDate);
DateArr[xInt, 1] = "E";
}
else
{
DateArr[xInt, 0] = Convert.ToString(xDate);
DateArr[xInt, 1] = "A";
}
xInt = xInt + 1;
}
//Next
rs = modRecordSet.getRS(ref "SELECT GRVPromotion.Promotion_Name, GRVPromotionItem.PromotionItem_StockItemID, GRVPromotionItem.PromotionItem_Price, GRVPromotion.Promotion_StartDate, GRVPromotion.Promotion_EndDate FROM GRVPromotion INNER JOIN GRVPromotionItem ON GRVPromotion.PromotionID = GRVPromotionItem.PromotionItem_PromotionID WHERE (((GRVPromotionItem.PromotionItem_StockItemID)=" + lID + "));");
if (rs.RecordCount > 0)
{
while (!rs.EOF)
{
xInt = 0;
for (xInt = 0; xInt <= Information.UBound(DateArr); xInt++)
{
if (DateArr[xInt, 0] == rs.Fields("Promotion_StartDate").Value)
{
if (DateArr[xInt, 1] == "E")
{
}
else
{
Interaction.MsgBox("Selected Item already part of '" + rs.Fields("Promotion_Name").Value + "' deal. Please use different date or exclude it from the other deals.");
rs.MoveLast();
rs.MoveNext();
return;
}
}
else if (DateArr[xInt, 0] == rs.Fields("Promotion_EndDate").Value)
{
if (DateArr[xInt, 1] == "S")
{
}
else
{
Interaction.MsgBox("Selected Item already part of '" + rs.Fields("Promotion_Name").Value + "' deal. Please use different date or exclude it from the other deals.");
rs.MoveLast();
rs.MoveNext();
return;
}
}
}
rs.MoveNext();
}
}
rs = modRecordSet.getRS(ref "SELECT GRVPromotion.Promotion_Name, GRVPromotionItem.PromotionItem_StockItemID, GRVPromotionItem.PromotionItem_Price, GRVPromotion.Promotion_StartDate, GRVPromotion.Promotion_EndDate FROM GRVPromotion INNER JOIN GRVPromotionItem ON GRVPromotion.PromotionID = GRVPromotionItem.PromotionItem_PromotionID WHERE (((GRVPromotionItem.PromotionItem_StockItemID)=" + lID + ") AND ((GRVPromotion.Promotion_StartDate)<=#" + Strings.Format(_DTFields_0.Value, "yyyy/MM/dd") + "#) AND ((GRVPromotion.Promotion_EndDate)>=#" + Strings.Format(_DTFields_1.Value, "yyyy/MM/dd") + "#));");
if (rs.RecordCount > 0)
{
Interaction.MsgBox("Selected Item already part of '" + rs.Fields("Promotion_Name").Value + "' deal. Please use different date or exclude it from the other deals.");
}
else
{
//cnnDB.Execute "INSERT INTO PromotionItem ( PromotionItem_PromotionID, PromotionItem_StockItemID, PromotionItem_Quantity, PromotionItem_Price ) SELECT " & adoPrimaryRS("PromotionID") & " AS [Set], CatalogueChannelLnk.CatalogueChannelLnk_StockItemID, 1,CatalogueChannelLnk.CatalogueChannelLnk_Price From CatalogueChannelLnk WHERE (((CatalogueChannelLnk.CatalogueChannelLnk_StockItemID)=" & lID & ") AND ((CatalogueChannelLnk.CatalogueChannelLnk_Quantity)=1) AND ((CatalogueChannelLnk.CatalogueChannelLnk_ChannelID)=1));"
My.MyProject.Forms.frmGRVPromotionItem.loadItem(adoPrimaryRS.Fields("PromotionID").Value, lID);
loadItems(lID);
}
}
}
void IC1ReportRecordset.MoveLast()
{
_rs.MoveLast();
}
private void cmdUndo_Click(System.Object eventSender, System.EventArgs eventArgs)
{
// ERROR: Not supported in C#: OnErrorStatement
ADODB.Recordset rs = default(ADODB.Recordset);
ADODB.Recordset rst = default(ADODB.Recordset);
ADODB.Recordset RsCh = default(ADODB.Recordset);
ADODB.Recordset rsIn = default(ADODB.Recordset);
rs = new ADODB.Recordset();
rst = new ADODB.Recordset();
rsIn = new ADODB.Recordset();
RsCh = modRecordSet.getRS(ref "SELECT * FROM BClabelItemUndo");
if (RsCh.RecordCount > 0) {
rs = modRecordSet.getRS(ref "SELECT * FROM BClabelItemUndo");
rs.MoveLast();
rsIn = modRecordSet.getRS(ref "SELECT * FROM BClabelItem WHERE BClabelItemID =" + rs.Fields("BClabelItemID").Value + " AND BClabelItem_Field='" + rs.Fields("BClabelItem_Field").Value + "'");
if (rsIn.RecordCount > 0) {
rst = modRecordSet.getRS(ref "DELETE * FROM BClabelItem WHERE BClabelItemID=" + rs.Fields("BClabelItemID").Value + "");
rst = modRecordSet.getRS(ref "DELETE * FROM BClabelItemUndo WHERE BClabelItemID=" + rs.Fields("BClabelItemID").Value + "");
} else if (rsIn.RecordCount < 1) {
rst = modRecordSet.getRS(ref "INSERT INTO BClabelItem(BClabelItem_BCLabelID,BClabelItem_Line,BClabelItem_Field,BClabelItem_Align,BClabelItem_Size,BClabelItem_Bold,BClabelItem_Sample,BClabelItem_Disabled,BClabelItem_LabelID)VALUES(" + rs.Fields("BClabelItem_BCLabelID").Value + "," + rs.Fields("BClabelItem_Line").Value + ",'" + rs.Fields("BClabelItem_Field").Value + "'," + rs.Fields("BClabelItem_Align").Value + "," + rs.Fields("BClabelItem_Size").Value + "," + rs.Fields("BClabelItem_Bold").Value + ",'" + rs.Fields("BClabelItem_Sample").Value + "'," + rs.Fields("BClabelItem_Disabled").Value + "," + rs.Fields("BClabelItem_LabelID").Value + ")");
rst = modRecordSet.getRS(ref "DELETE * FROM BClabelItemUndo WHERE BClabelItemID=" + rs.Fields("BClabelItemID").Value + " and BClabelItem_Field='" + rs.Fields("BClabelItem_Field").Value + "'");
}
modApplication.TheSelectedPrinterNew = 2;
labelsfile();
//Unload frmPrinter
//frmPrinter.selectPrinter
//frmBarcodedesign.TheLoading
//TheSelectedPrinterNew = 0
//cmdExit_Click
} else {
}
}
private void cmdExit_Click(System.Object eventSender, System.EventArgs eventArgs)
{
//On Error GoTo ErrH
ADODB.Recordset rs = default(ADODB.Recordset);
ADODB.Recordset rst = default(ADODB.Recordset);
ADODB.Recordset rsHave = default(ADODB.Recordset);
ADODB.Recordset rsMaxID = default(ADODB.Recordset);
short HoldBClabelItem_BCLabelID = 0;
string TheSample = null;
ADODB.Recordset rsInner = default(ADODB.Recordset);
short HoldLaIDVaBack = 0;
short TMaxID = 0;
rs = new ADODB.Recordset();
rst = new ADODB.Recordset();
rsHave = new ADODB.Recordset();
rsInner = new ADODB.Recordset();
rsMaxID = new ADODB.Recordset();
modApplication.IntDesign = 0;
//New code
rs = modRecordSet.getRS(ref "DELETE * FROM BClabelItemUndo");
strheight = 0;
strwidht = 0;
rs = modRecordSet.getRS(ref "SELECT * FROM LabelItem WHERE labelItem_LabelID=" + modApplication.MyLIDWHole + "");
if (rs.RecordCount == 1) {
rs = modRecordSet.getRS(ref "DELETE * FROM LabelItem WHERE labelItem_LabelID=" + modApplication.MyLIDWHole + "");
rs = modRecordSet.getRS(ref "DELETE * FROM Label WHERE LabelID=" + modApplication.MyLIDWHole + "");
rs = modRecordSet.getRS(ref "DELETE * FROM BClabel WHERE BClabel_LabelID=" + modApplication.MyLIDWHole + "");
rs = modRecordSet.getRS(ref "DELETE * FROM BClabelItem WHERE BClabelItem_LabelID=" + modApplication.MyLIDWHole + "");
this.Close();
My.MyProject.Forms.frmDesign.RefreshLoad(ref modApplication.TheType);
return;
} else {
}
rs = modRecordSet.getRS(ref "SELECT Max(LabelItem.labelItem_LabelID) as TheMaxID FROM LabelItem");
TMaxID = rs.Fields("TheMaxID").Value;
rs = modRecordSet.getRS(ref "SELECT * FROM LabelItem ORDER BY labelItem_LabelID");
rs.MoveFirst();
//Loading BClabelItem with Infor from LabelItem
while (!(rs.EOF)) {
// ERROR: Not supported in C#: OnErrorStatement
rsHave = modRecordSet.getRS(ref "SELECT * FROM BClabelItem WHERE BClabelItem_LabelID=" + rs.Fields("labelItem_LabelID").Value + "");
HoldBClabelItem_BCLabelID = rsHave.Fields("BClabelItem_BCLabelID").Value;
rst = modRecordSet.getRS(ref "DELETE * FROM BClabelItem WHERE BClabelItem_LabelID =" + rs.Fields("labelItem_LabelID").Value + "");
rsInner = modRecordSet.getRS(ref "SELECT * FROM LabelItem WHERE labelItem_LabelID=" + rs.Fields("labelItem_LabelID").Value + "");
while (!(rsInner.EOF)) {
if (Information.IsDBNull(rsInner.Fields("labelItem_Sample").Value)) {
TheSample = " ";
} else {
TheSample = rsInner.Fields("labelItem_Sample").Value;
}
rst = modRecordSet.getRS(ref "INSERT INTO BClabelItem(BClabelItem_BCLabelID,BClabelItem_Line,BClabelItem_Field,BClabelItem_Align,BClabelItem_Size,BClabelItem_Bold,BClabelItem_Sample,BClabelItem_Disabled,BClabelItem_LabelID)VALUES(" + HoldBClabelItem_BCLabelID + "," + rsInner.Fields("labelItem_Line").Value + ",'" + rsInner.Fields("labelItem_Field").Value + "'," + rsInner.Fields("labelItem_Align").Value + "," + rsInner.Fields("labelItem_Size").Value + "," + rsInner.Fields("labelItem_Bold").Value + ",'" + TheSample + "','" + 0 + "'," + rsInner.Fields("labelItem_LabelID").Value + ")");
rsInner.MoveNext();
}
HoldLaIDVaBack = rs.Fields("labelItem_LabelID").Value;
rs.MoveNext();
while (!(rs.Fields("labelItem_LabelID").Value != HoldLaIDVaBack)) {
if (rs.Fields("labelItem_LabelID").Value == TMaxID) {
rs.MoveLast();
rs.MoveNext();
break; // TODO: might not be correct. Was : Exit Do
}
rs.MoveNext();
}
}
this.Close();
My.MyProject.Forms.frmDesign.RefreshLoad(ref modApplication.TheType);
//ErrH: frmDesign.RefreshLoad TheType
//frmdesign.RefreshLoad TheType
}
