Esempio n. 1
0
        public string UserLogin(string username, string password)
        {
            //return msg data initialization
            DataSet ds = new DataSet();
            DataTable loginMsg = new DataTable();
            loginMsg.Columns.Add("Flag", typeof(Boolean));
            loginMsg.Columns.Add("Message", typeof(String));
            DataRow dr = loginMsg.NewRow();

            ClinicDAL.CryptographyFunctions crypto = new ClinicDAL.CryptographyFunctions();

            username = crypto.Decrypt(username);
            password = crypto.Decrypt(password);

            try
            {
                //user credentials checking
                ClinicDAL.UserAuthendication UA = new ClinicDAL.UserAuthendication(username, password);
                if (UA.ValidUser)
                {
                    dr["Flag"] = true;
                    dr["Message"] = UIClasses.Messages.LoginSuccess;
                    loginMsg.Columns.Add("ClinicID", typeof(String));
                    dr["ClinicID"] = UA.ClinicID;
                }
                else
                {
                    dr["Flag"] = false;
                    dr["Message"] = UIClasses.Messages.LoginFailed;
                }
            }
            catch (Exception ex)
            {
                dr["Flag"] = false;
                dr["Message"] = ex.Message;                 //exception message to be passed as JSON
            }
            finally
            {
                //returning data
                loginMsg.Rows.Add(dr);
                ds.Tables.Add(loginMsg);
            }
            return getDbDataAsJSON(ds);
        }
Esempio n. 2
0
        public String getDbDataAsJSON(DataSet ds)
        {
            ClinicDAL.CryptographyFunctions crypto = new ClinicDAL.CryptographyFunctions();
            try
            {
                DataTable dt = ds.Tables[0];
                System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
                List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>();
                Dictionary<string, object> row;
                foreach (DataRow dr in dt.Rows)
                {
                    row = new Dictionary<string, object>();
                    foreach (DataColumn col in dt.Columns)
                    {
                        row.Add(col.ColumnName, dr[col]);
                    }
                    rows.Add(row);
                }

                this.Context.Response.ContentType = "";

                return "[" + crypto.Encrypt(serializer.Serialize(rows)) + "]";

            }
            catch (Exception)
            {

                return "";
            }
            finally
            {

            }

        }