public void LoadNeedToReturn()
{
var data = ChBLL.ChallenView_RptUI(0, 0, "", "");
GVCOA.DataSource = data;
GVCOA.DataBind();
}
public void Search()
{ // (int id,string CoaNo, string accountName, int subcode_2id, string s2no, string s2name, string s1no, string s1name, string MHeadNo,string MHeadname)
var data = CBLL.LoadCoAInfo(0, txt_S_S2_COAID.Text.ToString(), txt_S_S2_COAName.Text.ToString(), 0, txt_S_S2_SucCode2_Id.Text.ToString(), txt_S_S2_SubCode2Name.Text.ToString(), txt_S_S2_SubCode1Id.Text.ToString(), txt_S_S2_SubCode1Name.Text.ToString(), txt_S_S2_MainHeadNo.Text.ToString(), txt_S_S2_MainHeadName.Text.ToString());
GVCOA.DataSource = data;
GVCOA.DataBind();
}
public void Search()
{
if (ddlCName_S.SelectedValue == "0" && txtReturnNo.Text == "" && txtDateTo.Text == "" && txtDateFrom.Text == "")
{
Show("Search By Valid Data");
}
else
{
int returnno = 0;
if (txtReturnNo.Text.ToString() != "")
{
returnno = Convert.ToInt32(txtReturnNo.Text);
}
else
{
returnno = 0;
}
var collection = BrBLL.Return_Branch_To_Central_ProductRpt_Detail(Convert.ToInt16(HFBranceId.Value), returnno, Convert.ToInt16(ddlCName_S.SelectedValue), txtDateFrom.Text.ToString(), txtDateTo.Text.ToString());
if (collection.Count == 0)
{
Show("No Data Found !");
return;
}
GVCOA.DataSource = collection;
GVCOA.DataBind();
LoadOtherEntity();
}
}
public void Search()
{
if (ddlBranch.SelectedValue == "0" && txtChallanNo.Text == "" && txtDateTo.Text == "" && txtDateFrom.Text == "")
{
Show("Search By Valid Data");
}
else
{
int chno = 0;
if (txtChallanNo.Text.ToString() != "")
{
chno = Convert.ToInt32(txtChallanNo.Text);
}
else
{
chno = 0;
}
var collection = ChBLL.ChallenView_RptUI(chno, Convert.ToInt32(ddlBranch.SelectedValue.ToString()), txtDateFrom.Text.ToString(), txtDateTo.Text.ToString());
if (collection.Count == 0)
{
Show("No Data Found !");
return;
}
GVCOA.DataSource = collection;
GVCOA.DataBind();
}
}
private void SearchReq()
{
if (txtDateTo.Text == "" && txtDateFrom.Text == "" && ddlBranch.SelectedValue == "0" && txtReqisitonNo.Text == "")
{
Show(" Plz Insert Data For Search");
return;
}
int reqno = 0;
if (txtReqisitonNo.Text.ToString() != "")
{
reqno = Convert.ToInt32(txtReqisitonNo.Text);
}
else
{
reqno = 0;
}
var search = ReqBLL.GetRequisition_PurOrderpage(txtDateFrom.Text, txtDateTo.Text, reqno, Convert.ToInt32(ddlBranch.SelectedValue));
if (search.Count == 0)
{
Show(" No data Found !");
return;
}
GVCOA.DataSource = search;
GVCOA.DataBind();
}
private void LoadPurReqGridView()
{
var search = ReqBLL.GetRequisition_PurOrderpage(txtDateFrom.Text, txtDateTo.Text, Convert.ToInt16(ddlCName_S.SelectedValue), Convert.ToInt16(ddlBranch.SelectedValue));
GVCOA.DataSource = search;
GVCOA.DataBind();
}
}// end of COA ID Generation
// GVCOA head code
private void loadDataGVCOA(int id, string CoaNo, string accountName, int subcode_2id, string s2no, string s2name, string s1no, string s1name, string MHeadNo, string MHeadname)
{
var data = CBLL.LoadCoAInfo(id, CoaNo, accountName, subcode_2id, s2no, s2name, s1no, s1name, MHeadNo, MHeadname);
GVCOA.DataSource = data;
GVCOA.DataBind();
//lblNoOFDataCount.Text = Convert.ToString( GVCOA.items.count);
}
private void LoadPurReqGridView()
{
var search = PurOrBLL.GetOrderNo_CentralPurchasepage(txtDateFrom.Text, txtDateTo.Text, Convert.ToInt16(ddlCName_S.SelectedValue), Convert.ToInt16(ddlRequisionNo.SelectedValue));
GVCOA.DataSource = search;
GVCOA.DataBind();
LoadOtherEntity();
}
public void LoadNeedToReturn()
{
var data = BrBLL.Return_Branch_To_Central_ProductRpt_Detail(Convert.ToInt16(HFBranceId.Value), 0, 0, "", "");
GVCOA.DataSource = data;
GVCOA.DataBind();
LoadOtherEntity();
}
public void LoadNeedToReturn()
{
var data = CentralBLL.Return_Central_To_Party_ProductRpt_Detail(0, 0, "", "");
GVCOA.DataSource = data;
GVCOA.DataBind();
LoadOtherEntity();
}
public void LoadListRequisitonNo()
{
DataTable dt = new DataTable();
DataRow dr;
ArrayList list = new ArrayList();
dt.Columns.Add(new System.Data.DataColumn("RequisitionNo", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("RequisitionBy", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("RequisitionDate", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("BrProName", typeof(String)));
int reqno = 0;
if (txtReqisitonNo.Text.ToString() != "")
{
reqno = Convert.ToInt32(txtReqisitonNo.Text);
}
else
{
reqno = 0;
}
// var data = PBLL.GetData(txtDateFrom.Text, txtDateTo.Text, Convert.ToInt32(ddlCName_S.SelectedValue), Convert.ToInt32(ddlMed_S.SelectedValue));
var data = ReqBLL.GetRequisition_PurOrderpage(txtDateFrom.Text, txtDateTo.Text, reqno, Convert.ToInt32(ddlBranch.SelectedValue));
for (int i = 0; i < data.Count; i++)
{
dr = dt.NewRow();
if (list.IndexOf(Convert.ToInt32(data[i].RequisitionNo.ToString())) == -1)
{
int Recno = Convert.ToInt32(data[i].RequisitionNo.ToString());
var data1 = ReqBLL.RequsiitonWiseProdctInfoLoad(Recno);
int flag = 0;
for (int j = 0; j < data1.Count; j++)
{
if (data1[j].PurReqStatus == "0")
{
flag = 1;
break;
}
}
if (flag == 1)
{
dr[0] = data[i].RequisitionNo;
dr[1] = data[i].RequisitionBy;
dr[2] = data[i].RequisitionDate.Value.ToShortDateString();
dr[3] = data[i].BrProName;
list.Add(Convert.ToInt32(data[i].RequisitionNo.ToString()));
dt.Rows.Add(dr);
}
}
}
GVCOA.DataSource = dt;
GVCOA.DataBind();
ViewState["CurrentData"] = dt;
list.Clear();
}
public void LoadList()
{
DataTable dt = new DataTable();
DataRow dr;
ArrayList list = new ArrayList();
dt.Columns.Add(new System.Data.DataColumn("RequisitionNo", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("RequisitionBy", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("RequisitionDate", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CompanyName", typeof(String)));
var data = ReqBLL.GetRequisition_CentralPurOrderpage(txtDateFrom.Text, txtDateTo.Text, Convert.ToInt32(ddlCName_S.SelectedValue), Convert.ToInt32(ddlRequisionNo.SelectedValue));
for (int i = 0; i < data.Count; i++)
{
dr = dt.NewRow();
if (list.IndexOf(Convert.ToInt32(data[i].RequisitionNo.ToString())) == -1)
{
int Recno = Convert.ToInt32(data[i].RequisitionNo.ToString());
var data1 = ReqBLL.GetInfo(Recno);
int flag = 0;
for (int j = 0; j < data1.Count; j++)
{
if (data1[j].PurReqStatus == "N")
{
flag = 1;
break;
}
}
if (flag == 1)
{
dr[0] = data[i].RequisitionNo;
dr[1] = data[i].RequisitionBy;
dr[2] = data[i].RequisitionDate;
dr[3] = data[i].CompName;
list.Add(Convert.ToInt32(data[i].RequisitionNo.ToString()));
dt.Rows.Add(dr);
}
}
}
GVCOA.DataSource = dt;
GVCOA.DataBind();
ViewState["CurrentData"] = dt;
list.Clear();
}
private void SearchReq()
{
if (txtDateTo.Text == "" && txtDateFrom.Text == "" && ddlRequisionNo.SelectedValue == "0" && ddlCName_S.SelectedValue == "0")
{
Show(" Plz Insert Data For Search");
return;
}
var search = ReqBLL.GetRequisition_CentralPurOrderpage(txtDateFrom.Text, txtDateTo.Text, Convert.ToInt16(ddlCName_S.SelectedValue), Convert.ToInt32(ddlRequisionNo.SelectedValue));
if (search.Count == 0)
{
Show(" No data Found !");
return;
}
GVCOA.DataSource = search;
GVCOA.DataBind();
}
