Beispiel #1
0
        public DataSet Login_RegisterStatus(string UserName, string Password, string SysDt, int StoreID, int StationID)
        {
            objData = new ClsData();
            DataSet dsAIPLData = new DataSet("AIPLData");

            if ((dtResult.Columns.Count == 0))
            {
                dtResult.Columns.Add("Result");
                dtResult.Columns.Add("Code");
                dtResult.Columns.Add("Description");
                dtResult.Rows.Add();
            }

            try
            {
                dsAIPLData = objData.Login_RegisterStatus(UserName, Password, SysDt, StoreID, StationID);

                if (dsAIPLData != null)
                {
                    if (dsAIPLData.Tables[0].Rows.Count > 0)
                    {
                        dtResult.Rows[0]["Result"]      = "A";
                        dtResult.Rows[0]["Code"]        = "000";
                        dtResult.Rows[0]["Description"] = "Success";
                        dtResult.AcceptChanges();
                        dsReturn.Tables.Add(dtResult);

                        for (int intFor = 0; intFor <= dsAIPLData.Tables.Count - 1; intFor++)
                        {
                            dsReturn.Tables.Add(dsAIPLData.Tables[intFor].Copy());
                        }
                    }
                }
                else
                {
                    dtResult.Rows[0]["Result"]      = "R";
                    dtResult.Rows[0]["Code"]        = "001";
                    dtResult.Rows[0]["Description"] = "No record found!";

                    dtResult.AcceptChanges();
                    dsReturn.Tables.Add(dtResult);
                }
                return(dsReturn);
            }
            catch (Exception ex)
            {
                SendEMail(ErrorMailSendTo, "Login_RegisterStatus", ex.Message.ToString());
                dtResult.Rows[0]["Result"]      = "R";
                dtResult.Rows[0]["Code"]        = "001";
                dtResult.Rows[0]["Description"] = ex.Message.ToString();

                dtResult.AcceptChanges();
                dsReturn.Tables.Add(dtResult);
                return(dsReturn);
            }
            finally
            {
                dsAIPLData = null;
                objData    = null;
            }
        }