public int Save_Rollback(int vInv_SqNo, int vTrLevel, int vComp_ID, int vBranch_ID, string vU_Name,
int vU_ID, string vAuth_D, int vFY_ID)
{
SqlCommand SCmd = new SqlCommand();
int nRet_Val = 0;
strErrorCode = "";
SCmd.Parameters.Clear();
SCmd.Parameters.Add(new SqlParameter("@nRetValue", SqlDbType.BigInt, 9, ParameterDirection.ReturnValue, false, 18, 1, "", DataRowVersion.Proposed, 0));
SCmd.Parameters.Add(new SqlParameter("@nInv_SqNo", SqlDbType.Int, 9, ParameterDirection.InputOutput, false, 18, 0, "", DataRowVersion.Proposed, vInv_SqNo));
SCmd.Parameters.Add(new SqlParameter("@nBranch_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vBranch_ID));
SCmd.Parameters.Add(new SqlParameter("@nComp_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vComp_ID));
SCmd.Parameters.Add(new SqlParameter("@nTrLevel", SqlDbType.Int, 4, ParameterDirection.Input, true, 18, 0, string.Empty, DataRowVersion.Proposed, vTrLevel));
SCmd.Parameters.Add(new SqlParameter("@nU_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 18, 0, string.Empty, DataRowVersion.Proposed, vU_ID));
SCmd.Parameters.Add(new SqlParameter("@sU_Name", SqlDbType.VarChar, 20, ParameterDirection.Input, true, 0, 0, string.Empty, DataRowVersion.Proposed, vU_Name));
SCmd.Parameters.Add(new SqlParameter("@sErr_Msg", SqlDbType.VarChar, 4000, ParameterDirection.InputOutput, false, 0, 0, string.Empty, DataRowVersion.Proposed, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@sAuth_D", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, vAuth_D));
SCmd.Parameters.Add(new SqlParameter("@dPDate", SqlDbType.DateTime, 8, ParameterDirection.InputOutput, false, 0, 0, string.Empty, DataRowVersion.Proposed, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@nIsUpdate", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, 7));
SCmd.Parameters.Add(new SqlParameter("@nFY_ID", SqlDbType.Int, 9, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, vFY_ID));
SCmd.Parameters.Add(new SqlParameter("@nApp_ID", SqlDbType.Int, 9, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, 9));
database1 clsdatabase1 = new database1();
clsdatabase1.Exec_Int_SP("stpInv_Tr_CS", SCmd);
strErrorCode = clsdatabase1.sErrorCode.Trim();
nRet_Val = Convert.ToInt32(SCmd.Parameters["@nRetValue"].Value);
try
{
strErr_Msg = SCmd.Parameters["@sErr_Msg"].Value.ToString();
}
catch { strErr_Msg = ""; }
return(nRet_Val);
}
private void Fill_Accounts()
{
database1 clsdatabase1 = new database1();
ACVoucher clsACVoucher = new ACVoucher();
DataSet ds = new DataSet();
int VrType = -1;
int Branch = mSys_System.pBranch_ID;
if (lookVrType.EditValue != null)
{
VrType = Convert.ToInt32(lookVrType.EditValue);
}
if (lookBranch_ID.EditValue != null)
{
Branch = Convert.ToInt32(lookBranch_ID.EditValue);
}
ds = clsACVoucher.Fill_Accounts(mSys_System.pComp_ID, Branch, mSys_System.pUser_ID, VrType);
if (clsACVoucher.strErrorCode != "")
{
clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsdatabase1.sErrorCode + "'", false);
return;
}
if (ds.Tables.Count > 0)
{
lookAcc.Properties.DataSource = ds.Tables[0];
lookAcc.Properties.DisplayMember = "Acc_Name";
lookAcc.Properties.ValueMember = "Acc_ID";
//Set_Combo(lookAcc, ds.Tables[0], "Acc_Name,", "Acc_ID", true);
}
}
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;
}
public int Get_UserLogOut(Int32 vSrNo)
{
database1 clsdatabase1 = new database1();
// SqlParameter[] param = new SqlParameter[15];
SqlCommand SCmd = new SqlCommand();
SCmd.Parameters.Add(new SqlParameter("@nRetValue", SqlDbType.Int, 4, ParameterDirection.ReturnValue, false, 0, 0, "", DataRowVersion.Default, 0));
SCmd.Parameters.Add(new SqlParameter("@nUser_ID", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Default, 0));
SCmd.Parameters.Add(new SqlParameter("@nUser_Branch_ID", SqlDbType.Int, 4, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@nUser_SrNo", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Default, vSrNo));
SCmd.Parameters.Add(new SqlParameter("@sUser_FName", SqlDbType.VarChar, 50, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, DBNull.Value));
// SCmd.Parameters.Add(new SqlParameter("@nUser_Dept_ID", SqlDbType.Int, 4, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@nUser_DaysLeft", SqlDbType.Int, 4, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, 0));
SCmd.Parameters.Add(new SqlParameter("@sBranch_Code", SqlDbType.VarChar, 5, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@sBranch_SName", SqlDbType.VarChar, 100, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@sBranch_FName", SqlDbType.VarChar, 100, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@nBranch_BrID", SqlDbType.Int, 4, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@bBranch_Bal", SqlDbType.Bit, 1, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, DBNull.Value));
// SCmd.Parameters.Add(new SqlParameter("@sBranch_MTI", SqlDbType.VarChar, 15, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, DBNull.Value));
//SCmd.Parameters.Add(new SqlParameter("@bBranch_Comm", SqlDbType.Bit, 1, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@dUser_LogInDate", SqlDbType.DateTime, 8, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@sComp_PassKey", SqlDbType.VarChar, 2000, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Default, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@sComp_FName", SqlDbType.VarChar, 100, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@nComp_ID", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Default, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@nIsUpdate", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, 3));
clsdatabase1.Exec_Int_SP("stpAdm_Login", SCmd);
strErrorCode = clsdatabase1.sErrorCode;
return(0);
}
public DataSet Find_Record_TR(string vTr_No, int vComp_ID, int vBranch_ID)
{
database1 clsdatabase1 = new database1();
DataSet ds_1;
SqlCommand SCmd = new SqlCommand();
//if (vInv_SqNo != "")
// SCmd.Parameters.Add(new SqlParameter("@nInv_SqNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, vInv_SqNo));
//else
// SCmd.Parameters.Add(new SqlParameter("@nInv_SqNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@sTr_No", SqlDbType.VarChar, 15, ParameterDirection.Input, true, 0, 0, string.Empty, DataRowVersion.Proposed, vTr_No));
SCmd.Parameters.Add(new SqlParameter("@nComp_ID", SqlDbType.Int, 9, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, vComp_ID));
SCmd.Parameters.Add(new SqlParameter("@sErr_Msg", SqlDbType.VarChar, 4000, ParameterDirection.InputOutput, false, 0, 0, string.Empty, DataRowVersion.Proposed, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@nBranch_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vBranch_ID));
SCmd.Parameters.Add(new SqlParameter("@nIsUpdate", SqlDbType.Int, 9, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, 17));
ds_1 = clsdatabase1.Get_DS_SP("stpInv_Tr_Transfer_In", SCmd);
strErrorCode = clsdatabase1.sErrorCode.Trim();
try
{
strErr_Msg = SCmd.Parameters["@sErr_Msg"].Value.ToString();
}
catch { strErr_Msg = ""; }
return(ds_1);
}
//private void btn_Print_Click(object sender, EventArgs e)
//{
// BMS.RptViewer frmRptViewer = new BMS.RptViewer();
// ParameterField rptParamField = new ParameterField();
// ParameterFields rptParamFields = new ParameterFields();
// ParameterDiscreteEditValue rptParamDiscreteEditValue = new ParameterDiscreteEditValue();
// ReportDocument rptDocument = new ReportDocument();
// string strRptNo = "";
// string strRpt = "";
// rptParamField = new ParameterField();
// rptParamDiscreteEditValue = new ParameterDiscreteEditValue();
// rptParamField.Name = "@nComp_ID";
// rptParamDiscreteEditValue.EditValue = mSys_System.pComp_ID.ToString();
// rptParamField.CurrentEditValues.Add(rptParamDiscreteEditValue);
// rptParamFields.Add(rptParamField);
// rptParamField = new ParameterField();
// rptParamDiscreteEditValue = new ParameterDiscreteEditValue();
// rptParamField.Name = "@nInv_SqNo";
// rptParamDiscreteEditValue.EditValue = lblInv_SqNo.Text;
// rptParamField.CurrentEditValues.Add(rptParamDiscreteEditValue);
// rptParamFields.Add(rptParamField);
// try
// {
// strRpt = Application.StartupPath;
// strRpt = strRpt.Substring(0, strRpt.Length - 3) + "Reports\\rptIN0021.rpt";
// rptDocument.Load(strRpt);
// Set_ReportConnection(rptDocument);
// }
// catch (Exception ex)
// {
// clsHomeScreen.Display_Message(ex.Message, string.Empty, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
// }
// //---Passing Report Formula's
// FormulaFieldDefinitions formulaList;
// formulaList = rptDocument.DataDefinition.FormulaFields;
// formulaList["CN"].Text = "'" + mSys_System.pCN.ToString().ToUpper() + "'";
// formulaList["Branch_Name"].Text = "'" + mSys_System.pBranch_SName.ToUpper() + "'";
// formulaList["Criteria1"].Text = "'Purchase Order'";
// formulaList["RPT"].Text = "'" + strRptNo + "'";
// formulaList["UserName"].Text = "'" + mSys_System.pUser_FullName + "'";
// //---Passing Selection formula
// rptDocument.DataDefinition.RecordSelectionFormula = "";
// //---Setting Report to view
// frmRptViewer.crv.ParameterFieldInfo = rptParamFields;
// frmRptViewer.crv.ReportSource = rptDocument;
// frmRptViewer.Show();
//}
//private void Set_ReportConnection(ReportDocument rptDocument)
//{
// TableLogOnInfo crLogonInfo;
// database1 clsDatabase1 = new database1();
// crLogonInfo = rptDocument.Database.Tables[0].LogOnInfo;
// crLogonInfo.ConnectionInfo.ServerName = database1.strServerName;
// crLogonInfo.ConnectionInfo.DatabaseName = database1.strDatabaseName;
// crLogonInfo.ConnectionInfo.UserID = database1.strUserID;
// crLogonInfo.ConnectionInfo.Password = database1.strPassword;
// rptDocument.Database.Tables[0].ApplyLogOnInfo(crLogonInfo);
//}
public void Find_Record_GRN(string GRN_Tr_No)
{
database1 clsdatabase1 = new database1();
INPR clsINPR = new INPR();
DataSet ds = new DataSet();
ds = clsINPR.Find_Record_GRN(mSys_System.pComp_ID, GRN_Tr_No);
if (clsINPR.sErrorCode != "")
{
clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsdatabase1.sErrorCode + "'", false);
return;
}
if (clsINPR.sErrorCode != "")
{
clsHomeScreen.Display_Message(clsINPR.sErrorCode + "'", false);
return;
}
if (ds.Tables.Count > 1)
{
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
lblGRN_Inv_SqNo.Text = dt.Rows[i]["Inv_SqNo"].ToString();
txtGRN_Tr_No.Text = dt.Rows[i]["Tr_No"].ToString();
dtpGRN_Tr_Date.Text = dt.Rows[i]["Tr_Date"].ToString();
lookSub_ID.EditValue = dt.Rows[i]["Sub__ID"].ToString();
cmbDept_ID.EditValue = (dt.Rows[i]["Dept_ID"] == null || dt.Rows[i]["Dept_ID"].ToString() == "" ? "-1" : dt.Rows[i]["Dept_ID"]);
cmbDept_ID_Store.EditValue = (dt.Rows[i]["Dept_ID_Store"] == null || dt.Rows[i]["Dept_ID_Store"].ToString() == "" ? "-1" : dt.Rows[i]["Dept_ID_Store"]);
cmbDept_ID_Store.Enabled = false;
cmbDept_ID.Enabled = false;
lookCredit_ID.EditValue = (dt.Rows[i]["Credit_ID"] == null || dt.Rows[i]["Credit_ID"].ToString() == "" ? "-1" : dt.Rows[i]["Credit_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_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();
txtInv_No.Text = dt.Rows[i]["Party_InvNo"].ToString();
txtGP_No.Text = dt.Rows[i]["GP_No"].ToString();
dtpGP_Date.Text = dt.Rows[i]["GP_Date"].ToString();
}
DataTable dt1 = ds.Tables[1];
gridControl1.DataSource = dt1;
Set_TrLevel();
}
}
public void Set_ReportConnection(ReportDocument rptDocument)
{
TableLogOnInfo crLogonInfo;
database1 clsDatabase1 = new database1();
crLogonInfo = rptDocument.Database.Tables[0].LogOnInfo;
crLogonInfo.ConnectionInfo.ServerName = database1.strServerName;
crLogonInfo.ConnectionInfo.DatabaseName = database1.strDatabaseName;
crLogonInfo.ConnectionInfo.UserID = database1.strUserID;
crLogonInfo.ConnectionInfo.Password = database1.strPassword;
rptDocument.Database.Tables[0].ApplyLogOnInfo(crLogonInfo);
}
public DataSet Fill_Combo(int vComp_ID, int vUser_ID)
{
database1 clsdatabase1 = new database1();
DataSet ds_1;
SqlCommand SCmd = new SqlCommand();
SCmd.Parameters.Add(new SqlParameter("@nComp_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, vComp_ID));
SCmd.Parameters.Add(new SqlParameter("@nU_S", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, vUser_ID));
SCmd.Parameters.Add(new SqlParameter("@nIsUpdate", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, 2));
ds_1 = clsdatabase1.Get_DS_SP("stpSys_Combo", SCmd);
strErrorCode = clsdatabase1.sErrorCode.Trim();
return(ds_1);
}
//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_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);
}
public DataSet Fill_Combo(int vComp_ID, int vBranch_ID, int vU_S, string Auth1, string Auth2)
{
DataSet ds_1;
SqlCommand SCmd = new SqlCommand();
database1 clsdatabase1 = new database1();
SCmd.Parameters.Add(new SqlParameter("@nComp_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, vComp_ID));
SCmd.Parameters.Add(new SqlParameter("@nBranch_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, vBranch_ID));
SCmd.Parameters.Add(new SqlParameter("@nU_S", SqlDbType.Int, 4, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, vU_S));
SCmd.Parameters.Add(new SqlParameter("@nIsUpdate", SqlDbType.Int, 4, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, 3));
ds_1 = clsdatabase1.Get_DS_SP("stpInv_Tr_Transfer", SCmd);
strErrorCode = clsdatabase1.sErrorCode.Trim();
return(ds_1);
}
public DataSet Fill_cfgP(int nComp_ID, int nBranch_ID)
{
DataTable dt = new DataTable();
DataSet ds_1;
database1 clsdatabase1 = new database1();
SqlCommand SCmd = new SqlCommand();
SCmd.Parameters.Add(new SqlParameter("@nComp_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, nComp_ID));
SCmd.Parameters.Add(new SqlParameter("@nBranch_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, nBranch_ID));
SCmd.Parameters.Add(new SqlParameter("@nIsUpdate", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, 0));
ds_1 = clsdatabase1.Get_DS_SP("stpInv_Tr_Transfer", SCmd);
strErrorCode = clsdatabase1.sErrorCode.Trim();
return(ds_1);
}
public DataTable Get_Emp(int vIsUpdate, string vE_IDNo, int vComp_ID)
{
database1 clsdatabase1 = new database1();
DataSet ds_1;
DataTable dt = new DataTable();
SqlCommand SCmd = new SqlCommand();
SCmd.Parameters.Add(new SqlParameter("@sE_IDNo", SqlDbType.VarChar, 15, ParameterDirection.Input, false, 0, 0, string.Empty, DataRowVersion.Proposed, vE_IDNo));
SCmd.Parameters.Add(new SqlParameter("@nComp_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 18, 0, string.Empty, DataRowVersion.Proposed, vComp_ID));
SCmd.Parameters.Add(new SqlParameter("@nIsUpdate", SqlDbType.Int, 4, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, vIsUpdate));
ds_1 = clsdatabase1.Get_DS_SP("stpInv_Tr_Transfer", SCmd);
strErrorCode = clsdatabase1.sErrorCode.Trim();
dt = ds_1.Tables[0];
return(dt);
}
private void Fill_SCat()
{
database1 clsdatabase1 = new database1();
INSub_Category clsINSub_Category = new INSub_Category();
DataSet ds = new DataSet();
ds = clsINSub_Category.Fill_Combo(mSys_System.pComp_ID, mSys_System.pUser_ID);
if (clsINSub_Category.sErrorCode != "")
{
clsHomeScreen.Display_Message(clsdatabase1.sErrorCode, false);
return;
}
Set_Combo(lookSCat_ID, ds.Tables[0], "SCat_DD", "SCat_ID", true);
}
private void Fill_Grid_2()
{
database1 clsdatabase1 = new database1();
INItem clsINItem = new INItem();
DataSet ds = new DataSet();
ds = clsINItem.Fill_Grid(mSys_System.pComp_ID, mSys_System.pUser_ID, "");
if (clsINItem.sErrorCode != "")
{
clsHomeScreen.Display_Message(clsdatabase1.sErrorCode, false);
return;
}
DataTable dt = ds.Tables[0];
gridControl_Item.DataSource = dt;
}
public DataTable Load_List(string vSearch, DateTime vDateFrom, DateTime vDateTo, int vBranch_ID, int vComp_ID)
{
database1 clsdatabase1 = new database1();
DataSet ds_1 = new DataSet();
SqlCommand SCmd = new SqlCommand();
SCmd.Parameters.Add(new SqlParameter("@sSearchText", SqlDbType.VarChar, 15, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vSearch));
//SCmd.Parameters.Add(new SqlParameter("@nTrLevel", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vTrLevel));
SCmd.Parameters.Add(new SqlParameter("@dBegDate", SqlDbType.DateTime, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vDateFrom));
SCmd.Parameters.Add(new SqlParameter("@dEndDate", SqlDbType.DateTime, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vDateTo));
SCmd.Parameters.Add(new SqlParameter("@nComp_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vComp_ID));
SCmd.Parameters.Add(new SqlParameter("@nBranch_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vBranch_ID));
SCmd.Parameters.Add(new SqlParameter("@nIsUpdate", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, 1));
ds_1 = clsdatabase1.Get_DS_SP("[stpInv_Tr_Transfer]", SCmd);
strErrorCode = clsdatabase1.sErrorCode.Trim();
return(ds_1.Tables[0]);
}
public DataTable Get_ItemD(string vSearch, int vBranch_ID, int So_ID, int vComp_ID, int vDept_ID_Store)
{
database1 clsdatabase1 = new database1();
DataSet ds_1 = new DataSet();
SqlCommand SCmd = new SqlCommand();
SCmd.Parameters.Add(new SqlParameter("@nSO_ID", SqlDbType.Int, 15, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, So_ID));
SCmd.Parameters.Add(new SqlParameter("@sSearch", SqlDbType.VarChar, 15, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vSearch));
SCmd.Parameters.Add(new SqlParameter("@nComp_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vComp_ID));
SCmd.Parameters.Add(new SqlParameter("@nDept_ID_Store", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vDept_ID_Store));
SCmd.Parameters.Add(new SqlParameter("@nBranch_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vBranch_ID));
SCmd.Parameters.Add(new SqlParameter("@nIsUpdate", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, 7));
ds_1 = clsdatabase1.Get_DS_SP("stpInv_Tr_Transfer", SCmd);
strErrorCode = clsdatabase1.sErrorCode.Trim();
return(ds_1.Tables[0]);
}
private void Fill_Combo()
{
database1 clsdatabase1 = new database1();
INItem_OB clsINItem_OB = new INItem_OB();
DataSet ds = new DataSet();
ds = clsINItem_OB.Fill_Combo(mSys_System.pComp_ID, mSys_System.pUser_ID);
if (clsINItem_OB.sErrorCode != "")
{
clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsdatabase1.sErrorCode + "'", false);
return;
}
Set_Combo(lookBranch_ID, ds.Tables[0], "Branch_SName", "Branch_ID", true);
Set_Combo(lookDept_ID_Store, ds.Tables[1], "Dept_DD", "Dept_ID", true);
Set_Combo(lookGrade_ID, ds.Tables[2], "Grade_ID", "Grade_ID", false);
}
public int Save_Authorize(int vInv_SqNo, string vTr_No, DateTime vTr_Date, DateTime vFYSDate, int vBranch_ID, int vDept_ID,
int vDept_ID_Store, double vQty_Total, double vQty_FOC, string vRef1, string vRef2, int vTrLevel,
int vComp_ID, string vU_Name, int vU_ID, string vAuth_D, int vFY_ID)
{
SqlCommand SCmd = new SqlCommand();
int nRet_Val = 0;
strErrorCode = "";
SCmd.Parameters.Clear();
SCmd.Parameters.Add(new SqlParameter("@nRetValue", SqlDbType.BigInt, 9, ParameterDirection.ReturnValue, false, 18, 1, "", DataRowVersion.Proposed, 0));
SCmd.Parameters.Add(new SqlParameter("@nInv_SqNo", SqlDbType.Int, 9, ParameterDirection.InputOutput, false, 18, 0, "", DataRowVersion.Proposed, vInv_SqNo));
SCmd.Parameters.Add(new SqlParameter("@sTr_No", SqlDbType.VarChar, 20, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Proposed, vTr_No));
SCmd.Parameters.Add(new SqlParameter("@dTr_Date", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, vTr_Date.Date));
SCmd.Parameters.Add(new SqlParameter("@dFYSDate", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, vFYSDate.Date));
SCmd.Parameters.Add(new SqlParameter("@nDept_ID", SqlDbType.Int, 9, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, vDept_ID));
SCmd.Parameters.Add(new SqlParameter("@nDept_ID_Store", SqlDbType.Int, 9, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, vDept_ID_Store));
SCmd.Parameters.Add(new SqlParameter("@nBranch_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vBranch_ID));
SCmd.Parameters.Add(new SqlParameter("@nComp_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vComp_ID));
SCmd.Parameters.Add(new SqlParameter("@nTrLevel", SqlDbType.Int, 4, ParameterDirection.Input, true, 18, 0, string.Empty, DataRowVersion.Proposed, vTrLevel));
SCmd.Parameters.Add(new SqlParameter("@nU_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 18, 0, string.Empty, DataRowVersion.Proposed, vU_ID));
SCmd.Parameters.Add(new SqlParameter("@nQty_Total", SqlDbType.Money, 9, ParameterDirection.Input, false, 18, 2, "", DataRowVersion.Proposed, vQty_Total));
SCmd.Parameters.Add(new SqlParameter("@nQty_FOC", SqlDbType.Money, 9, ParameterDirection.Input, false, 18, 2, "", DataRowVersion.Proposed, vQty_FOC));
SCmd.Parameters.Add(new SqlParameter("@sU_Name", SqlDbType.VarChar, 20, ParameterDirection.Input, true, 0, 0, string.Empty, DataRowVersion.Proposed, vU_Name));
SCmd.Parameters.Add(new SqlParameter("@sErr_Msg", SqlDbType.VarChar, 4000, ParameterDirection.InputOutput, false, 0, 0, string.Empty, DataRowVersion.Proposed, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@sRef1", SqlDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, vRef1));
SCmd.Parameters.Add(new SqlParameter("@sRef2", SqlDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, vRef2));
SCmd.Parameters.Add(new SqlParameter("@sAuth_D", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, vAuth_D));
SCmd.Parameters.Add(new SqlParameter("@dPDate", SqlDbType.DateTime, 8, ParameterDirection.InputOutput, false, 0, 0, string.Empty, DataRowVersion.Proposed, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@nIsUpdate", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, 5));
SCmd.Parameters.Add(new SqlParameter("@nFY_ID", SqlDbType.Int, 9, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, vFY_ID));
SCmd.Parameters.Add(new SqlParameter("@nApp_ID", SqlDbType.Int, 9, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, 9));
database1 clsdatabase1 = new database1();
clsdatabase1.Exec_Int_SP_S("stpInv_Tr_CS", SCmd);
strErrorCode = clsdatabase1.sErrorCode.Trim();
nRet_Val = Convert.ToInt32(SCmd.Parameters["@nRetValue"].Value);
try
{
strErr_Msg = SCmd.Parameters["@sErr_Msg"].Value.ToString();
}
catch { strErr_Msg = ""; }
return(nRet_Val);
}
private void Find_Record_2(int ID)
{
database1 clsdatabase1 = new database1();
INItem clsINItem = new INItem();
DataSet ds = new DataSet();
ds = clsINItem.Find_Record(mSys_System.pComp_ID, ID);
if (clsINItem.sErrorCode != "")
{
clsHomeScreen.Display_Message(clsdatabase1.sErrorCode, false);
return;
}
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
lblItem_ID.Text = dt.Rows[i]["Item_ID"].ToString();
txtItem_D.Text = dt.Rows[i]["Item_D"].ToString();
txtItem_DD.Text = dt.Rows[i]["Item_DD"].ToString();
txtItem_Rate.Text = dt.Rows[i]["Item_Rate"].ToString();
txtItem_SrNo.Text = dt.Rows[i]["Item_SrNo"].ToString();
txtMax_Level.Text = dt.Rows[i]["Max_Level"].ToString();
txtMin_Level.Text = dt.Rows[i]["Min_Level"].ToString();
txtA_UnitFactor.Text = dt.Rows[i]["A_UnitFactor"].ToString();
txtItem_BarCode.Text = dt.Rows[i]["Item_BarCode"].ToString();
lookUnit_ID.EditValue = (dt.Rows[i]["Unit_ID"] == null || dt.Rows[i]["Unit_ID"].ToString() == "") ? null : dt.Rows[i]["Unit_ID"];
lookA_Unit_ID.EditValue = (dt.Rows[i]["A_Unit_ID"] == null || dt.Rows[i]["A_Unit_ID"].ToString() == "") ? null : dt.Rows[i]["A_Unit_ID"];
lookCat_ID.EditValue = (dt.Rows[i]["Cat_ID"] == null || dt.Rows[i]["Cat_ID"].ToString() == "") ? null : dt.Rows[i]["Cat_ID"];
lookSCat_ID.EditValue = (dt.Rows[i]["SCat_ID"] == null || dt.Rows[i]["SCat_ID"].ToString() == "") ? null : dt.Rows[i]["SCat_ID"];
lookIType_ID.EditValue = (dt.Rows[i]["IType_ID"] == null || dt.Rows[i]["IType_ID"].ToString() == "") ? null : dt.Rows[i]["IType_ID"];
lookSize_ID.EditValue = (dt.Rows[i]["Size_ID"] == null || dt.Rows[i]["Size_ID"].ToString() == "") ? null : dt.Rows[i]["Size_ID"];
chkItem_Active.Checked = Convert.ToBoolean(dt.Rows[i]["Item_Active"]);
chkIsA_Unit.Checked = Convert.ToBoolean(dt.Rows[i]["IsA_Unit"]);
chkItem_A1.Checked = Convert.ToBoolean(dt.Rows[i]["Item_A1"]);
chkItem_A2.Checked = Convert.ToBoolean(dt.Rows[i]["Item_A2"]);
chkItem_A3.Checked = Convert.ToBoolean(dt.Rows[i]["Item_A3"]);
chkItem_A4.Checked = Convert.ToBoolean(dt.Rows[i]["Item_A4"]);
chkItem_A5.Checked = Convert.ToBoolean(dt.Rows[i]["Item_A5"]);
}
}
public int Save_App_Level_1(DateTime vTr_Date, string vFYSDate, int vDept_ID_Store, int vBranch_ID, Int32 vInvSqNo, string vVrNo, int vVrType,
string vRef4, int vFY_ID, int vU_S, string vU_Name, int vComp_ID)
{
database1 clsdatabase1 = new database1();
DataSet ds_1 = new DataSet();
SqlCommand SCmd = new SqlCommand();
SCmd.Parameters.Add(new SqlParameter("@nRetValue", SqlDbType.Int, 4, ParameterDirection.ReturnValue, false, 0, 0, "", DataRowVersion.Default, 0));
SCmd.Parameters.Add(new SqlParameter("@nComp_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 18, 1, "", DataRowVersion.Proposed, vComp_ID));
SCmd.Parameters.Add(new SqlParameter("@nDept_ID_Store", SqlDbType.Int, 4, ParameterDirection.Input, false, 18, 1, "", DataRowVersion.Proposed, vDept_ID_Store));
SCmd.Parameters.Add(new SqlParameter("@nBranch_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vBranch_ID));
SCmd.Parameters.Add(new SqlParameter("@nInv_SqNo", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Default, vInvSqNo));
SCmd.Parameters.Add(new SqlParameter("@sTr_No", SqlDbType.VarChar, 15, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Default, vVrNo));
SCmd.Parameters.Add(new SqlParameter("@nTrLevel", SqlDbType.Int, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, 58));
SCmd.Parameters.Add(new SqlParameter("@nVrType", SqlDbType.Int, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vVrType));
SCmd.Parameters.Add(new SqlParameter("@nItem_ID1", SqlDbType.Int, 8, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, 0));
SCmd.Parameters.Add(new SqlParameter("@dFYSDate", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vFYSDate));
//SCmd.Parameters.Add(new SqlParameter("@sErrorMessage", SqlDbType.VarChar, 200, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@sRef4", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vRef4.Trim()));
SCmd.Parameters.Add(new SqlParameter("@nFY_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 18, 1, "", DataRowVersion.Proposed, vFY_ID));
SCmd.Parameters.Add(new SqlParameter("@nU_S", SqlDbType.Int, 9, ParameterDirection.Input, false, 18, 1, "", DataRowVersion.Proposed, vU_S));
SCmd.Parameters.Add(new SqlParameter("@sErr_Msg", SqlDbType.VarChar, 200, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@sU_Name", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vU_Name.Trim()));
SCmd.Parameters.Add(new SqlParameter("@nIsUpdate", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, 28));
clsdatabase1.Exec_Int_SP_S("stpInv_Tr_Transfer", SCmd);
strErrorCode = clsdatabase1.sErrorCode.Trim();
if (strErrorCode == "")
{
strErrorCode = SCmd.Parameters["@sErr_Msg"].Value.ToString();
}
try
{
vItem_ID = SCmd.Parameters["@nItem_ID1"].Value.ToString();
}
catch { vItem_ID = ""; }
sErr_Msg = SCmd.Parameters["@sErr_Msg"].Value.ToString();
return(Convert.ToInt32(SCmd.Parameters["@nRetValue"].Value));
}
public int Save_Cancel(int nInv_SqNo, int vBranch_ID, int vComp_ID, int vU_S, string vU_Name)
{
database1 clsdatabase1 = new database1();
SqlCommand SCmd = new SqlCommand();
int strRecAffected = 0;
SCmd.Parameters.Add(new SqlParameter("@nRetValue", SqlDbType.Int, 4, ParameterDirection.ReturnValue, false, 0, 0, "", DataRowVersion.Proposed, 0));
SCmd.Parameters.Add(new SqlParameter("@nInv_SqNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, nInv_SqNo));
SCmd.Parameters.Add(new SqlParameter("@nBranch_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vBranch_ID));
SCmd.Parameters.Add(new SqlParameter("@nComp_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vComp_ID));
SCmd.Parameters.Add(new SqlParameter("@nU_S", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vU_S));
SCmd.Parameters.Add(new SqlParameter("@sU_Name", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, vU_Name));
SCmd.Parameters.Add(new SqlParameter("@nIsUpdate", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, 11));
strRecAffected = clsdatabase1.Exec_Int_SP("[stpInv_Tr_DP]", SCmd);
strErrorCode = clsdatabase1.sErrorCode.Trim();
nRet_Val = Convert.ToInt32(SCmd.Parameters["@nRetValue"].Value);
return(nRet_Val);
}
private void Fill_Combo()
{
database1 clsdatabase1 = new database1();
INItem clsINItem = new INItem();
DataSet ds = new DataSet();
ds = clsINItem.Fill_Combo(mSys_System.pComp_ID, mSys_System.pUser_ID);
if (clsINItem.sErrorCode != "")
{
clsHomeScreen.Display_Message(clsdatabase1.sErrorCode, false);
return;
}
Fill_Cat();
Fill_SCat();
Set_Combo(lookIType_ID, ds.Tables[0], "IType_DD", "IType_ID", true);
Set_Combo(lookSize_ID, ds.Tables[1], "Size_DD", "Size_ID", true);
Set_Combo(lookUnit_ID, ds.Tables[2], "Unit_DD", "Unit_ID", true);
Set_Combo(lookA_Unit_ID, ds.Tables[2], "Unit_DD", "Unit_ID", true);
}
public DataSet Fill_Grid(string vSearch, int vTrLevel, string vDateFrom, string vDateTo, int vBranch_ID, int vDept_ID_Store, int vComp_ID, int vPageNo)
{
database1 clsdatabase1 = new database1();
DataSet ds_1 = new DataSet();
SqlCommand SCmd = new SqlCommand();
SCmd.Parameters.Add(new SqlParameter("@sSearch", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vSearch));
SCmd.Parameters.Add(new SqlParameter("@nTrLevel", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vTrLevel));
SCmd.Parameters.Add(new SqlParameter("@dBeg_Date", SqlDbType.DateTime, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vDateFrom));
SCmd.Parameters.Add(new SqlParameter("@dEnd_Date", SqlDbType.DateTime, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vDateTo));
SCmd.Parameters.Add(new SqlParameter("@nComp_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vComp_ID));
SCmd.Parameters.Add(new SqlParameter("@nDept_ID_Store", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vDept_ID_Store));
SCmd.Parameters.Add(new SqlParameter("@nBranch_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vBranch_ID));
SCmd.Parameters.Add(new SqlParameter("@nPageNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, vPageNo));
SCmd.Parameters.Add(new SqlParameter("@nIsUpdate", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, 13));
ds_1 = clsdatabase1.Get_DS_SP("[stpInv_Tr_Transfer]", SCmd);
strErrorCode = clsdatabase1.sErrorCode.Trim();
return(ds_1);
}
public int Save_Delete(int vItem_ID, string sGrade_ID, int vpComp_ID, int vBranch_ID, int vDept_ID_Store, int vU_S, int vIsUpdate, string vAuth_D)
{
database1 clsdatabase1 = new database1();
SqlDataAdapter da = new SqlDataAdapter();
SqlConnection SConnection = new SqlConnection();
SConnection.ConnectionString = clsdatabase1.Getdatabase1();
SConnection.Open();
SqlCommand Cmm = new SqlCommand("stpInv_Item_OB", SConnection);
try
{
Cmm.Parameters.Add(new SqlParameter("@nItem_ID", SqlDbType.Int, 9, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, vItem_ID));
Cmm.Parameters.Add(new SqlParameter("@nComp_ID", SqlDbType.Int, 9, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, vpComp_ID));
Cmm.Parameters.Add(new SqlParameter("@nBranch_ID", SqlDbType.Int, 9, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, vBranch_ID));
Cmm.Parameters.Add(new SqlParameter("@nDept_ID", SqlDbType.Int, 9, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, vDept_ID_Store));
Cmm.Parameters.Add(new SqlParameter("@nU_S", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, vU_S));
Cmm.Parameters.Add(new SqlParameter("@sGrade_ID", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, sGrade_ID));
Cmm.Parameters.Add(new SqlParameter("@sAuth_D", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, vAuth_D));
Cmm.Parameters.Add(new SqlParameter("@nIsUpdate", SqlDbType.Int, 9, ParameterDirection.Input, false, 18, 0, "", DataRowVersion.Proposed, vIsUpdate));
Cmm.Parameters.Add(new SqlParameter("@nReturn", SqlDbType.BigInt, 9, ParameterDirection.ReturnValue, false, 18, 0, "", DataRowVersion.Proposed, 0));
Cmm.CommandType = CommandType.StoredProcedure;
Cmm.ExecuteNonQuery();
}
catch (Exception ex)
{
return(0);
}
try
{
sErrorCode = clsDatabase1.sErrorCode;
}
catch (Exception)
{
sErrorCode = "";
}
int strRetValue = Convert.ToInt32(Cmm.Parameters["@nReturn"].Value);
return(strRetValue);
}
private void lookBranch_ID_EditValueChanged(object sender, EventArgs e)
{
database1 clsdatabase1 = new database1();
INGRN clsINGRN = new INGRN();
DataSet ds = new DataSet();
int vBranch = -1;
if (lookBranch_ID.EditValue != null)
{
vBranch = Convert.ToInt32(lookBranch_ID.EditValue);
}
ds = clsINGRN.Fill_Combo(mSys_System.pComp_ID, mSys_System.pUser_ID, vBranch);
if (clsINGRN.sErrorCode != "")
{
clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsdatabase1.sErrorCode + "'", false);
return;
}
Set_Combo(cmbDept_ID, ds.Tables[0], "Dept_DD", "Dept_ID", true);
Set_Combo(cmbDept_ID_Store, ds.Tables[1], "Dept_DD", "Dept_ID", true);
Set_Combo(lookSub_ID, ds.Tables[2], "Sub_CodeD", "Sub_ID", true);
}
private void Find_Record(int ID)
{
database1 clsdatabase1 = new database1();
INCategory clsINCategory = new INCategory();
DataSet ds = new DataSet();
ds = clsINCategory.Find_Record(mSys_System.pComp_ID, ID);
if (clsINCategory.sErrorCode != "")
{
clsHomeScreen.Display_Message(clsdatabase1.sErrorCode, false);
return;
}
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
lblCat_ID.Text = dt.Rows[i]["Cat_ID"].ToString();
txtCat_D.Text = dt.Rows[i]["Cat_D"].ToString();
txtCat_DD.Text = dt.Rows[i]["Cat_DD"].ToString();
}
}
private void Fill_Combo()
{
database1 clsdatabase1 = new database1();
ACVoucher clsACVoucher = new ACVoucher();
DataSet ds = new DataSet();
ds = clsACVoucher.Fill_Combo(mSys_System.pComp_ID, mSys_System.pUser_ID);
if (clsACVoucher.strErrorCode != "")
{
clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsdatabase1.sErrorCode + "'", false);
return;
}
if (ds.Tables.Count > 0)
{
lookVrType.Properties.DataSource = ds.Tables[0];
lookVrType.Properties.DisplayMember = "VrTypeDD";
lookVrType.Properties.ValueMember = "VrType";
lookVrType_Serch.Properties.DataSource = ds.Tables[0];
lookVrType_Serch.Properties.DisplayMember = "VrTypeDD";
lookVrType_Serch.Properties.ValueMember = "VrType";
lookBranch_ID.Properties.DataSource = ds.Tables[1];
lookBranch_ID.Properties.DisplayMember = "Branch_FName";
lookBranch_ID.Properties.ValueMember = "Branch_ID";
lookBranch_Search.Properties.DataSource = ds.Tables[1];
lookBranch_Search.Properties.DisplayMember = "Branch_FName";
lookBranch_Search.Properties.ValueMember = "Branch_ID";
lookTrLevel.Properties.DataSource = ds.Tables[2];
lookTrLevel.Properties.DisplayMember = "TrLevelD";
lookTrLevel.Properties.ValueMember = "TrLevel";
//Set_Combo(lookVrType, ds.Tables[0], "VrTypeDD,", "VrType", true);
//Set_Combo(lookVrType_Serch, ds.Tables[0], "VrTypeDD,", "VrType", true);
//Set_Combo(lookBranch_ID, ds.Tables[1], "Branch_FName,", "Branch_ID", true);
//Set_Combo(lookBranch_Search, ds.Tables[1], "Branch_FName,", "Branch_ID", true);
//Set_Combo(lookTrLevel, ds.Tables[1], "TrLevelD,", "TrLevel", true);
}
}
public int Save_Cancelled(int vBranch_ID, Int32 vInvSqNo, string vRef4, int vFY_ID, int vU_S, string vU_Name, int vComp_ID)
{
database1 clsdatabase1 = new database1();
DataSet ds_1 = new DataSet();
SqlCommand SCmd = new SqlCommand();
SCmd.Parameters.Add(new SqlParameter("@nRetValue", SqlDbType.Int, 4, ParameterDirection.ReturnValue, false, 0, 0, "", DataRowVersion.Default, 0));
SCmd.Parameters.Add(new SqlParameter("@nInv_SqNo", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Default, vInvSqNo));
SCmd.Parameters.Add(new SqlParameter("@nVrType", SqlDbType.Int, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, cn_VrType));
SCmd.Parameters.Add(new SqlParameter("@nComp_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 18, 1, "", DataRowVersion.Proposed, vComp_ID));
SCmd.Parameters.Add(new SqlParameter("@nBranch_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vBranch_ID));
SCmd.Parameters.Add(new SqlParameter("@sRef4", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vRef4.Trim()));
SCmd.Parameters.Add(new SqlParameter("@nFY_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 18, 1, "", DataRowVersion.Proposed, vFY_ID));
SCmd.Parameters.Add(new SqlParameter("@sErr_Msg", SqlDbType.VarChar, 200, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, DBNull.Value));
SCmd.Parameters.Add(new SqlParameter("@nU_S", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vU_S));
SCmd.Parameters.Add(new SqlParameter("@sU_Name", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, vU_Name.Trim()));
SCmd.Parameters.Add(new SqlParameter("@nIsUpdate", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, 29));
clsdatabase1.Exec_Int_SP("stpInv_Tr_Transfer", SCmd);
strErrorCode = clsdatabase1.sErrorCode.Trim();
sErr_Msg = SCmd.Parameters["@sErr_Msg"].Value.ToString();
return(Convert.ToInt32(SCmd.Parameters["@nRetValue"].Value));
}
private void Fill_Grid()
{
ACVoucher clsACVoucher = new ACVoucher();
DataSet ds_Record = new DataSet();
DataTable dt_1 = new DataTable();
int nBranch_ID = -1;
int nVrType = -1;
int nTrLevel = -1;
object dBegDate = dtpBegDate.EditValue;
object dEndDate = dtpEndDate.EditValue;
if (lookBranch_Search.EditValue != null)
{
nBranch_ID = Convert.ToInt32(lookBranch_Search.EditValue);
}
if (lookTrLevel.EditValue != null)
{
nTrLevel = Convert.ToInt32(lookTrLevel.EditValue);
}
if (lookVrType_Serch.EditValue != null)
{
nVrType = Convert.ToInt32(lookVrType_Serch.EditValue);
}
database1 clsdatabase1 = new database1();
DataSet ds = new DataSet();
ds = clsACVoucher.Fill_Grid(mSys_System.pComp_ID, nBranch_ID, nVrType, nTrLevel, dBegDate, dEndDate, txtSearch.Text.Trim(), mSys_System.pUser_ID);
if (clsACVoucher.strErrorCode != "")
{
clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsACVoucher.strErrorCode + "'", false);
return;
}
DataTable dt = ds.Tables[0];
gridControl2.DataSource = dt;
}
