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);
}
