public partial class Transactions_NewStockAdjustment : System.Web.UI.Page

{

    string StrDocNo = String.Empty;

​

    CommandFunction CF = new CommandFunction();

​

    protected void Page_Load(object sender, EventArgs e)

    {

        if (Request.QueryString["Mode"] != null && Request.QueryString["Mode"] != "")

            Hid_Mode.Value = Request.QueryString["Mode"].ToString();

        else

            Hid_Mode.Value = "A";

​

        if (Request.QueryString["Mkey"] != null && Request.QueryString["Mkey"] != "")

            Hid_MKey.Value = Request.QueryString["Mkey"].ToString();

        else

            Hid_MKey.Value = "0";

        if (Request.QueryString["userid"] != null && Request.QueryString["userid"] != "")

        {

            Hid_userid.Value = "1";

        }

​

        if (!IsPostBack)

        {

            BindAdjReason();

            BindRegion();

            BindAdjustmentType();

​

            if (ddlAdjustmentType.SelectedValue == "9")

            {

                BindItemCode("select distinct REPLACE(Current_Item_Code  + ' '  + QUOTENAME(Current_Item_Desc,'()'), '*','') as ItemCode, " +

                              "Current_Item_Code from WMS_Storage_Bin where status='Confirmed'");

            }

            if (ddlAdjustmentType.SelectedValue == "10")

            {

                BindItemCodeaddStock("select distinct (Navision_Item_Id + ' ' + QUOTENAME(Item_short_desc, '()')) as AddStock, " +

                                      "Navision_Item_Id from Item_mst");

            }

​

            txtAdjustmentDt.Value = DateTime.Now.ToString("dd/MM/yyyy").Replace("-", "/");

            CalEntryDt1.DateMin = System.DateTime.Now;

        }

​

    }

​

​

    protected void BindAdjReason()

    {

        DataTable dtregion = CF.ExecuteDT("select type_desc,Master_mkey from type_Mst_a where type_code='DR'");

        ddladjReason.DataTextField = "Type_Desc";

        ddladjReason.DataValueField = "Master_Mkey";

        ddladjReason.DataSource = dtregion;

        ddladjReason.DataBind();

        ddladjReason.Items.Insert(0, new ListItem("--Select--", "0"));

    }

​

    public void BindRegion()

    {

        DataTable dtregion = CF.ExecuteDT("select Type_Desc, Master_Mkey from type_mst_a where type_code='RL'");

        ddlRegion.DataTextField = "Type_Desc";

        ddlRegion.DataValueField = "Master_Mkey";

        ddlRegion.DataSource = dtregion;

        ddlRegion.DataBind();

        ddlRegion.Items.Insert(0, new ListItem("---Select---", "0"));

    }

​

    public void BindAdjustmentType()

    {

        DataTable dtadjtype = CF.ExecuteDT("select Type_Desc, Master_Mkey from type_mst_a where type_code='SA'");

        ddlAdjustmentType.DataTextField = "Type_Desc";

        ddlAdjustmentType.DataValueField = "Master_Mkey";

        ddlAdjustmentType.DataSource = dtadjtype;

        ddlAdjustmentType.DataBind();

        ddlAdjustmentType.Items.Insert(0, new ListItem("---Select---", "0"));

    }

​

    public void BindItemCode(string query)

    {

        DataTable dtitemcode = CF.ExecuteDT(query);

        ddlItemCode.DataTextField = "ItemCode";

        ddlItemCode.DataValueField = "Current_Item_Code";

        ddlItemCode.DataSource = dtitemcode;

        ddlItemCode.DataBind();

        ddlItemCode.Items.Insert(0, new ListItem("--Select--", "0"));

    }

​

    public void BindItemCodeaddStock(string query)

    {

        DataTable dtadditemcode = CF.ExecuteDT(query);

        ddlItemCode.DataTextField = "AddStock";

        ddlItemCode.DataValueField = "Navision_Item_Id";

        ddlItemCode.DataSource = dtadditemcode;

        ddlItemCode.DataBind();

        ddlItemCode.Items.Insert(0, new ListItem("--Select--", "0"));

    }

​

    public void BindBin(string query)

    {

        DataTable dtbinNo = CF.ExecuteDT(query);

        ddlBinNo.DataTextField = "Location_Name";

        ddlBinNo.DataValueField = "Mkey";

        ddlBinNo.DataSource = dtbinNo;

        ddlBinNo.DataBind();

        ddlBinNo.Items.Insert(0, new ListItem("---Select---", "0"));

    }

​

    //public void BindItemDesc(string query)

    //{

    //    DataTable dtitemdesc = CF.ExecuteDT(query);

    //    ddlItemdesc.DataTextField = "Current_Item_Desc";

    //    ddlItemdesc.DataValueField = "Mkey";

    //    ddlItemdesc.DataSource = dtitemdesc;

    //    ddlItemdesc.DataBind();

    //    ddlItemdesc.Items.Insert(0, new ListItem("---Select---", "0"));

    //}

​

    //[WebMethod]

    //public static List<string> GetItemCode(string ItemCode)

    //{

    //    List<string> itemcode = new List<string>();

​

    //    if (!string.IsNullOrEmpty(ItemCode))

    //    {

    //        DataTable DtBuild = new DataTable();

    //        SqlConnection Conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["SqlConn"].ToString());

    //        Conn.Open();

​

    //        string StrPriQry = "select distinct Current_Item_Code + '~'  + CAST(mkey as nvarchar) from "+

    //                           "WMS_Storage_Bin where status='Confirmed' and current_item_code ='" + ItemCode.Trim() + "'";

    //        SqlDataAdapter ObjPriBuild = new SqlDataAdapter(StrPriQry, Conn);

    //        ObjPriBuild.Fill(DtBuild);

    //        for (int i = 0; i < DtBuild.Rows.Count; i++)

    //        {

    //            itemcode.Add(DtBuild.Rows[i][0].ToString());

    //        }

    //        Conn.Close();

    //    }

    //    return itemcode;

​

    //}

​

    [WebMethod]

    public static List<string> GetItemdesc(string Itemdesc)

    {

        List<string> itemdesc = new List<string>();

​

        if (!string.IsNullOrEmpty(Itemdesc))

        {

            DataTable DtBuild = new DataTable();

            SqlConnection Conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["SqlConn"].ToString());

            Conn.Open();

​

            string StrPriQry = "select distinct REPLACE(Current_Item_Desc, '*', '') from WMS_Storage_Bin where "+

                               "status='Confirmed' and Current_Item_Code='" + Itemdesc.Trim() + "'";

            SqlDataAdapter ObjPriBuild = new SqlDataAdapter(StrPriQry, Conn);

            ObjPriBuild.Fill(DtBuild);

            for (int i = 0; i < DtBuild.Rows.Count; i++)

            {

                itemdesc.Add(DtBuild.Rows[i][0].ToString());

            }

            Conn.Close();

        }

        return itemdesc;

​

    }

​

​

    [WebMethod]

    public static List<string> GetItemDescBin(string ItemdescBin)

    {

        List<string> itemdescbin = new List<string>();

​

        if (!string.IsNullOrEmpty(ItemdescBin))

        {

            DataTable DtBuild = new DataTable();

            SqlConnection Conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["SqlConn"].ToString());

            Conn.Open();

​

            string StrPriQry = "select distinct Current_Item_Desc  from WMS_Storage_Bin where " +

                               "status='Confirmed' and Location_Name='" + ItemdescBin.Trim() + "'";

            SqlDataAdapter ObjPriBuild = new SqlDataAdapter(StrPriQry, Conn);

            ObjPriBuild.Fill(DtBuild);

            for (int i = 0; i < DtBuild.Rows.Count; i++)

            {

                itemdescbin.Add(DtBuild.Rows[i][0].ToString());

            }

            Conn.Close();

        }

        return itemdescbin;

​

    }

​

​

    [WebMethod]

    public static List<string> GetBinNo(string BinNo)

    {

        List<string> binno = new List<string>();

​

        if (!string.IsNullOrEmpty(BinNo))

        {

            DataTable DtBuild = new DataTable();

            SqlConnection Conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["SqlConn"].ToString());

            Conn.Open();

​

            string StrPriQry = "select distinct  Location_Name + '^' +  convert(varchar, mkey), Current_item_desc from WMS_Storage_Bin " +

                                "where status='Confirmed' and Current_Item_code='" + BinNo.Trim() + "'";

​

​

            SqlDataAdapter ObjPriBuild = new SqlDataAdapter(StrPriQry, Conn);

            ObjPriBuild.Fill(DtBuild);

            for (int i = 0; i < DtBuild.Rows.Count; i++)

            {

                binno.Add(DtBuild.Rows[i][0].ToString());

            }

            Conn.Close();

        }

        return binno;

    }

​

    [WebMethod]

    public static string GetLotNo(string LotNo)

    {

        string exp = "";

        DataTable Dtexp = new DataTable();

        SqlConnection Conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["SqlConn"].ToString());

        Conn.Open();

        SqlDataAdapter ObjPriState = new SqlDataAdapter("select distinct Current_Item_Batch  from WMS_Storage_Bin where " +

                                                          "status='Confirmed' and Location_Name='" + LotNo.Trim() + "'", Conn);

​

​

        ObjPriState.Fill(Dtexp);

        if (Dtexp.Rows.Count > 0)

            exp = Dtexp.Rows[0][0].ToString();

​

        Conn.Close();

        return exp;

​

    }

​

    [WebMethod]

    public static string GetExpdate(string expdtfortext)

    {

        string expdt = "";

        DataTable Dtexp = new DataTable();

        SqlConnection Conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["SqlConn"].ToString());

        Conn.Open();

        SqlDataAdapter ObjPriState = new SqlDataAdapter("select distinct convert(varchar, Current_Item_Exp_Dt, 103) from WMS_Storage_Bin where " +

                                                          "status='Confirmed' and Location_Name='" + expdtfortext.Trim() + "'", Conn);

​

​

        ObjPriState.Fill(Dtexp);

        if (Dtexp.Rows.Count > 0)

            expdt = Dtexp.Rows[0][0].ToString();

​

        Conn.Close();

        return expdt;

​

    }

​

    [WebMethod]

    public static string GetQuanAvailable(string quanavail)

    {

        string quaavail = "";

        DataTable dtquant = new DataTable();

        SqlConnection Conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["SqlConn"].ToString());

        Conn.Open();

        SqlDataAdapter ObjPriState = new SqlDataAdapter("select distinct Unit_Availabe from WMS_Storage_Bin where status='Confirmed' " +

                                                         "and Location_Name='" + quanavail.Trim() + "'", Conn);

​

​

        ObjPriState.Fill(dtquant);

        if (dtquant.Rows.Count > 0)

            quaavail = dtquant.Rows[0][0].ToString();

​

        Conn.Close();

        return quaavail;

​

    }

​

}