private void get_Sale() { database1 clsdatabase1 = new database1(); INCSR clsINCSR = new INCSR(); DataSet ds = new DataSet(); ds = clsINCSR.Find_Sale(mSys_System.pComp_ID, txtDoc_Tr_No.Text.Trim()); if (clsINCSR.strErrorCode != "") { clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsdatabase1.sErrorCode + "'", false); return; } DataTable dt = ds.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { lblDoc_Inv_SqNo.Text = dt.Rows[i]["Inv_SqNo"].ToString(); txtDoc_Tr_No.Text = dt.Rows[i]["Tr_No"].ToString(); dtpDoc_Tr_Date.Text = dt.Rows[i]["Tr_Date"].ToString(); lookSub_ID.EditValue = dt.Rows[i]["Sub_ID"].ToString(); txtRef1.Text = dt.Rows[i]["Ref1"].ToString(); txtContact_Person.Text = dt.Rows[i]["Person"].ToString(); txtAddress1.Text = dt.Rows[i]["Address1"].ToString(); txtAddress2.Text = dt.Rows[i]["Address2"].ToString(); txtCell.Text = dt.Rows[i]["Cell"].ToString(); } DataTable dt1 = ds.Tables[1]; gridControl1.DataSource = dt1; }
private void btn_Authorize_Click(object sender, ItemClickEventArgs e) { INCSR clsINCSR = new INCSR(); int nRet_Val = 0; if (lblInv_SqNo.Text == "") { clsHomeScreen.Display_Message("Please select a record to Authorize...", false); return; } //---alert if (XtraMessageBox.Show(cnMsg_BeforeAuthorize_1, string.Empty, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } //strAuth_D = mSys_IN.pcU_M_09_C09_A; int nDept_ID = -1; int nDept_ID_Store = -1; int nBranch_ID = -1; double nQty_Item = Convert.ToDouble(gridView1.Columns["I_Qty"].SummaryItem.SummaryValue); if (lookDept_ID.EditValue != null && lookDept_ID.EditValue.ToString() != "") { nDept_ID = Convert.ToInt32(lookDept_ID.EditValue.ToString()); } if (lookDept_ID_Store.EditValue != null && lookDept_ID_Store.EditValue.ToString() != "") { nDept_ID_Store = Convert.ToInt32(lookDept_ID_Store.EditValue.ToString()); } nRet_Val = clsINCSR.Save_Authorize(Convert.ToInt32(lblInv_SqNo.Text), txtTr_No.Text.Trim(), Convert.ToDateTime(dtpTr_Date.EditValue), mSys_System.pFYSDate, nBranch_ID, nDept_ID, nDept_ID_Store, nQty_Item, txtRef1.Text, "", mSys_System.pTrLevel_Cleared, mSys_System.pComp_ID, mSys_System.pUserName, mSys_System.pUser_ID, strAuth_D, mSys_System.pFY_ID); if (clsINCSR.strErrorCode.Trim() != "") { clsHomeScreen.Display_Message(cnMsg_ErrSaveUpdate + clsINCSR.strErrorCode + "....................", false); return; } if (nRet_Val == 1) { clsHomeScreen.Display_Message(cnMsg_SaveUpdateComplete, false); lblTrLevel.Text = mSys_System.pTrLevel_Approved.ToString(); Set_TrLevel(); return; } else if (nRet_Val == -1) { clsHomeScreen.Display_Message(clsINCSR.strErr_Msg, false); return; } }
private void Fill_Combo() { database1 clsdatabase1 = new database1(); INCSR clsINCSR = new INCSR(); DataSet ds = clsINCSR.Fill_Combo(mSys_System.pComp_ID, mSys_System.pUser_ID); if (clsINCSR.sErrorCode != "") { clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsdatabase1.sErrorCode + "'", false); return; } Set_Combo(lookBranch_ID, ds.Tables[0], "Branch_SName", "Branch_ID", true); Set_Combo(lookDType, ds.Tables[2], "DType_DD", "DType_ID", true); }
//private void Fill_Grid() //{ // INCSR clsINCSR = new INCSR(); // DataSet ds_Record = new DataSet(); // DataTable dt_1 = new DataTable(); // string strSearch_1 = ""; // string strSearch_2 = ""; // string strSearch_3 = ""; // string strSearchText = txtSearch.Text.Trim(); // string[] strArr; // strArr = strSearchText.Split(" ".ToCharArray()); // for (int i = 0; i < strArr.Length; i++) // { // if (i == 0) // { // strSearch_1 = strArr[0].ToString(); continue; // } // if (i == 1) // { // strSearch_2 = strArr[1].ToString(); continue; // } // if (i == 2) // { // strSearch_3 = strArr[2].ToString(); continue; // } // } // int nBranch_ID = -1; // int nDept_ID = -1; // int nDept_ID_Store_1 = -1; // int nTrLevel = -1; // DateTime dBegDate = Convert.ToDateTime(dtpBegDate.EditValue); // DateTime dEndDate = Convert.ToDateTime(dtpEndDate.EditValue); // //if (cmbBranch_ID.EditValue != null && cmb1Branch_ID.EditValue.ToString() != "") nBranch_ID = Convert.ToInt32(cmb1Branch_ID.EditValue.ToString()); // if (cmb1TrLevel.EditValue != null && cmb1TrLevel.EditValue.ToString() != "") nTrLevel = Convert.ToInt32(cmb1TrLevel.EditValue.ToString()); // if (cmb1Dept_ID_Store.EditValue != null && cmb1Dept_ID_Store.EditValue.ToString() != "") nDept_ID = Convert.ToInt32(cmb1Dept_ID_Store.EditValue.ToString()); // if (cmb1Dept_ID.EditValue != null && cmb1Dept_ID.EditValue.ToString() != "") nDept_ID_Store_1 = Convert.ToInt32(cmb1Dept_ID.EditValue.ToString()); // database1 clsdatabase1 = new database1(); // DataSet ds = new DataSet(); // ds = clsINCSR.Fill_Grid(mSys_System.pComp_ID, nTrLevel, "", strSearch_1, mSys_System.pBranch_ID, nDept_ID, nDept_ID_Store_1, dBegDate, dEndDate, 1); // if (clsINCSR.strErrorCode != "") // { // clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsINCSR.sErrorCode + "'", false); // return; // } // //Set_Grid(); // DataTable dt = ds.Tables[0]; // gridControl3.DataSource = dt; //} private void Find_Record(int ID) { database1 clsdatabase1 = new database1(); INCSR clsINCSR = new INCSR(); DataSet ds = new DataSet(); ds = clsINCSR.Find_Record(mSys_System.pComp_ID, ID); if (clsINCSR.strErrorCode != "") { clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsdatabase1.sErrorCode + "'", false); return; } DataTable dt = ds.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { lblInv_SqNo.Text = dt.Rows[i]["Inv_SqNo"].ToString(); txtTr_No.Text = dt.Rows[i]["Tr_No"].ToString(); dtpTr_Date.Text = dt.Rows[i]["Tr_Date"].ToString(); lookSub_ID.EditValue = dt.Rows[i]["Sub_ID"].ToString(); lookDept_ID.EditValue = (dt.Rows[i]["Dept_ID"] == null || dt.Rows[i]["Dept_ID"].ToString() == "" ? "-1" : dt.Rows[i]["Dept_ID"]); lookDept_ID_Store.EditValue = (dt.Rows[i]["Dept_ID_Store"] == null || dt.Rows[i]["Dept_ID_Store"].ToString() == "" ? "-1" : dt.Rows[i]["Dept_ID_Store"]); lookDType.EditValue = (dt.Rows[i]["DType_ID"] == null || dt.Rows[i]["DType_ID"].ToString() == "" ? "-1" : dt.Rows[i]["DType_ID"]); //cmbCC.EditValue = (dt.Rows[i]["cmbCC"] == null || dt.Rows[i]["cmbCC"].ToString() == "" ? "-1" : dt.Rows[i]["cmbCC"]); txtAmt_Item.Text = dt.Rows[i]["Amt_Item"].ToString(); txtAmt_Total.Text = dt.Rows[i]["Amt_Total"].ToString(); txtAmt_CC.Text = dt.Rows[i]["Amt_CC"].ToString(); txtAmt_Cash.Text = dt.Rows[i]["Amt_Cash"].ToString(); txtAmt_Dis.Text = dt.Rows[i]["Amt_Dis"].ToString(); //txtAmt_R1.Text = dt.Rows[i]["Amt_R1"].ToString(); txtAmt_Bal.Text = dt.Rows[i]["Amt_Bal"].ToString(); lblTrLevel.Text = dt.Rows[i]["TrLevel"].ToString(); lblTrLevelD.Text = dt.Rows[i]["TrLevelD"].ToString(); txtRef1.Text = dt.Rows[i]["Ref1"].ToString(); txtContact_Person.Text = dt.Rows[i]["Person"].ToString(); txtAddress1.Text = dt.Rows[i]["Address1"].ToString(); txtAddress2.Text = dt.Rows[i]["Address2"].ToString(); txtCell.Text = dt.Rows[i]["Cell"].ToString(); //dtpGP_Date.Text = dt.Rows[i]["GP_Date"].ToString(); } DataTable dt1 = ds.Tables[1]; gridControl1.DataSource = dt1; Set_TrLevel(); }
private void Fill_SubCat() { INCSR clsINCSR = new INCSR(); DataSet ds = clsINCSR.Fill_CatSub(mSys_System.pComp_ID, mSys_System.pUser_ID); DataTable dt = ds.Tables[0]; DataRow row = dt.NewRow(); row["SCat_DD"] = string.Empty; row["SCat_ID"] = 0; dt.Rows.InsertAt(row, 0); repositoryItemGridLookUpEdit1.DataSource = dt; repositoryItemGridLookUpEdit1.ValueMember = "SCat_DD"; repositoryItemGridLookUpEdit1.DisplayMember = "SCat_DD"; gridView1.Columns["SCat_DD"].ColumnEdit = repositoryItemGridLookUpEdit1; }
private void btn_Rollback_Click(object sender, ItemClickEventArgs e) { int nRet_Val = 0; INCSR clsINCSR = new INCSR(); if (lblInv_SqNo.Text == "") { clsHomeScreen.Display_Message("Please select a record to Rollback...", false); return; } //---user authorizations //if (!(pUser_Auth(pcU_M_09_C03_D, 1, 1))) //{ // return; //} //---alert if (XtraMessageBox.Show(cnMsg_BeforeRollback, string.Empty, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } //strAuth_D = mSys_IN.pcU_M_09_C09_RB; nRet_Val = clsINCSR.Save_Rollback(Convert.ToInt32(lblInv_SqNo.Text), Convert.ToInt32(lblTrLevel.Text), mSys_System.pComp_ID, mSys_System.pBranch_ID, mSys_System.pUserName, mSys_System.pUser_ID, strAuth_D, mSys_System.pFY_ID); if (clsINCSR.strErrorCode.Trim() != "") { clsHomeScreen.Display_Message(cnMsg_ErrSaveUpdate + clsINCSR.strErrorCode + "....................", false); return; } if (nRet_Val == 1) { clsHomeScreen.Display_Message(cnMsg_SaveUpdateComplete, false); lblTrLevel.Text = mSys_System.pTrLevel_Pending.ToString(); Set_TrLevel(); return; } else if (nRet_Val == -1) { clsHomeScreen.Display_Message(clsINCSR.strErr_Msg, false); return; } }
private void lookBranch_ID_EditValueChanged(object sender, EventArgs e) { database1 clsdatabase1 = new database1(); INCSR clsINCSR = new INCSR(); DataSet ds = new DataSet(); int vBranch = -1; if (lookBranch_ID.EditValue != null) { vBranch = Convert.ToInt32(lookBranch_ID.EditValue); } ds = clsINCSR.Fill_Combo(mSys_System.pComp_ID, mSys_System.pUser_ID, vBranch); if (clsINCSR.sErrorCode != "") { clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsdatabase1.sErrorCode + "'", false); return; } Set_Combo(lookDept_ID, ds.Tables[0], "Dept_DD", "Dept_ID", true); Set_Combo(lookDept_ID_Store, ds.Tables[1], "Dept_DD", "Dept_ID", true); Set_Combo(lookSub_ID, ds.Tables[2], "Sub_DD", "Sub_ID", true); }
private bool Save_Update(int IsUpdate) { INCSR clsINCSR = new INCSR(); int Ret_Value = 0; if (IsUpdate == 0) { //---alert //strAuth_D = ""; if (XtraMessageBox.Show(Msg_BeforeSave, string.Empty, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return(false); } } else if (IsUpdate == 1) //---update { //strAuth_D = ""; //---alert if (XtraMessageBox.Show(Msg_BeforeUpdate, string.Empty, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return(false); } } DataTable dt_1 = Set_Grid(); for (int i = 0; i < gridView1.DataRowCount; i++) { DataRow row = dt_1.NewRow(); if (gridView1.GetRowCellValue(i, "Item_ID") != null) { if (gridView1.GetRowCellValue(i, "Item_ID").ToString() != "") { row["Item_ID"] = gridView1.GetRowCellValue(i, "Item_ID"); row["SCat_ID"] = gridView1.GetRowCellValue(i, "SCat_ID"); if (gridView1.GetRowCellValue(i, "I_Qty").ToString() == "") { row["I_Qty"] = 0; } else { row["I_Qty"] = gridView1.GetRowCellValue(i, "I_Qty"); } if (gridView1.GetRowCellValue(i, "I_Qty_FOC").ToString() == "") { row["I_Qty_FOC"] = 0; } else { row["I_Qty_FOC"] = gridView1.GetRowCellValue(i, "I_Qty_FOC"); } //row["I_Qty_FOC"] = gridView1.GetRowCellValue(i, "I_Qty_FOC"); row["R_Qty"] = gridView1.GetRowCellValue(i, "R_Qty"); row["R_Qty_FOC"] = gridView1.GetRowCellValue(i, "R_Qty_FOC"); row["R_Rate"] = gridView1.GetRowCellValue(i, "R_Rate"); row["S_Rate"] = gridView1.GetRowCellValue(i, "S_Rate"); //row["Item_Rate_Min"] = gridView1.GetRowCellValue(i, "Item_Rate_Min"); //row["Item_Rate_Max"] = gridView1.GetRowCellValue(i, "Item_Rate_Max"); row["Rate_1"] = gridView1.GetRowCellValue(i, "Rate_1"); row["Ref4"] = gridView1.GetRowCellValue(i, "Ref4"); dt_1.Rows.Add(row); } } } List <DataRow> Child = new List <DataRow>(dt_1.Select()); string TrType = "Cash"; int CC = 0; int nDType_ID = 0; int nTrType = 0; int Dept_ID = 0; int Dept_ID_Store = 0; int Branch_ID = 0; nTrType = 15; if (lblTrType.Text == "CREDIT") { nTrType = 16; } string CurrID = "PKR"; double Curr_Rate = 0; double Amt_Cash = txtAmt_Cash.Text == "" ? 0 : Convert.ToDouble(txtAmt_Cash.Text); double Amt_CC = txtAmt_CC.Text == "" ? 0 : Convert.ToDouble(txtAmt_CC.Text); double Amt_Bal = txtAmt_Bal.Text == "" ? 0 : Convert.ToDouble(txtAmt_Bal.Text); double Amt_Item = txtAmt_Item.Text == "" ? 0 : Convert.ToDouble(txtAmt_Item.Text); double Amt_Total = txtAmt_Total.Text == "" ? 0 : Convert.ToDouble(txtAmt_Total.Text); double Amt_Dis = txtAmt_Dis.Text == "" ? 0 : Convert.ToDouble(txtAmt_Dis.Text); double Qty_Item = Convert.ToDouble(gridView1.Columns["R_Qty"].SummaryItem.SummaryValue); double Qty_FOC = Convert.ToDouble(gridView1.Columns["R_Qty_FOC"].SummaryItem.SummaryValue); double GST_Total = Convert.ToDouble(gridView1.Columns["Amt_R1"].SummaryItem.SummaryValue); if (cmbCC.EditValue != null && cmbCC.EditValue.ToString() != "") { CC = Convert.ToInt32(cmbCC.EditValue.ToString()); } if (lookDType.EditValue != null && lookDType.EditValue.ToString() != "") { nDType_ID = Convert.ToInt32(lookDType.EditValue.ToString()); } if (lookDept_ID.EditValue != null && lookDept_ID.EditValue.ToString() != "") { Dept_ID = Convert.ToInt32(lookDept_ID.EditValue.ToString()); } if (lookDept_ID_Store.EditValue != null && lookDept_ID_Store.EditValue.ToString() != "") { Dept_ID_Store = Convert.ToInt32(lookDept_ID_Store.EditValue.ToString()); } int nRet_Val = clsINCSR.Save_Master(lblInv_SqNo.Text, lblDoc_Inv_SqNo.Text.Trim(), txtTr_No.Text.Trim(), Convert.ToDateTime(dtpTr_Date.EditValue), mSys_System.pComp_ID, Convert.ToInt32(lookSub_ID.GetColumnValue("Detail_ID")), Convert.ToInt32(lookSub_ID.GetColumnValue("Sub_ID")), Dept_ID, Dept_ID_Store, Branch_ID, txtAddress1.Text, txtAddress2.Text, "", txtContact_Person.Text, txtCell.Text, nDType_ID, CurrID, Curr_Rate, CC, nTrType, txtRef1.Text.Trim(), "", Qty_Item, Qty_FOC, Amt_Item, Amt_Dis, Amt_Total, Amt_Bal, Amt_Cash, Amt_CC, GST_Total, Child, mSys_System.pTrLevel_Pending, mSys_System.pUserName, mSys_System.pUser_ID, IsUpdate, strAuth_D, mSys_System.pFY_ID); if (clsINCSR.sErrorCode != "") { clsHomeScreen.Display_Message(clsINCSR.sErrorCode + "......", false); return(false); } if (nRet_Val == -1) { clsHomeScreen.Display_Message(clsINCSR.strErr_Msg + "....................", false); return(false); } if (nRet_Val == 0) { clsHomeScreen.Display_Message(Msg_ErrSaveUpdate + "....................", false); return(false); } if (nRet_Val == 1) { txtTr_No.Text = clsINCSR.str_Tr_No; lblInv_SqNo.Text = clsINCSR.str_Inv_SqNo.ToString(); //lblU_S.Text = clsINCSR.strU_S; //lblPDate.Text = clsINCSR.strPDate; //lblU_U.Text = clsINCSR.strU_U; //lblU_UD.Text = clsINCSR.strU_UD; clsHomeScreen.Display_Message(Msg_SaveUpdateComplete + "....................", false); } return(true); }