public List <string> FirstBLL()
        {
            clsDAL        obj       = new clsDAL();
            List <string> skillList = obj.First();

            return(skillList);
        }
        public void updateAnsweredBLL(int rno, string s, string cocode)
        {
            rno++;
            clsDAL ob = new clsDAL();

            ob.updateAnswered(rno, s, cocode);
        }
        public int QuestionnumberfinderBLL(string s)
        {
            clsDAL ob = new clsDAL(); int n = 0;

            n = ob.Questionnumberfinder(s);
            return(n);
        }
        public List <string> CourseDetailsPageBLL(UserBO ob)
        {
            clsDAL        obj      = new clsDAL();
            List <string> cDetails = obj.CourseDetails(ob);

            return(cDetails);
        }
        public List <string> First3BLL()
        {
            clsDAL        obj        = new clsDAL();
            List <string> skillList3 = obj.First3();

            return(skillList3);
        }
        public List <string> First2BLL()
        {
            clsDAL        obj        = new clsDAL();
            List <string> skillList2 = obj.First2();

            return(skillList2);
        }
        public List <string> getScoreDetailsBLL(UserBO ob)
        {
            clsDAL        obj       = new clsDAL();
            List <string> skillList = obj.getScoreDetails(ob);

            return(skillList);
        }
        public string ComplaintSupport()
        {
            //Retrieve POST data
            string jsonComplaintDetail = Request.Content.ReadAsStringAsync().Result;

            clsDAL objDAL = new clsDAL();
            return objDAL.complaintSupport(jsonComplaintDetail).ToJSON();
        }
        public string DeleteAccount()
        {
            //Retrieve POST data
            string accountId = Request.Content.ReadAsStringAsync().Result;

            clsDAL objDAL = new clsDAL();
            return objDAL.deleteAccount(accountId).ToJSON();
        }
Пример #10
0
        public string ImageUpload()
        {
            //Retrieve POST data
            string imageData = Request.Content.ReadAsStringAsync().Result;

            clsDAL objDAL = new clsDAL();
            return objDAL.imageUpload(imageData).ToJSON();
        }
Пример #11
0
        private void ContentUpGeneric(DataTable dt, int Rows, string strExcelFileName)
        {
            clsDAL      objDAL;
            AirtelModel objAirtelModel = new AirtelModel();

            objAirtelModel.ExcelFileName = strExcelFileName;
            objAirtelModel.ContentDate   = Convert.ToDateTime(dt.Rows[Rows]["Date"].ToString()).ToString("MM/dd/yyyy");
            objAirtelModel.ContentText   = dt.Rows[Rows]["F2"].ToString().Replace("'", null);
            objAirtelModel.ContentMonth  = ContentMonth(objAirtelModel.ContentDate);
            objAirtelModel.SheetName     = TableNameFormat(dt.TableName.ToString());

            objDAL = new clsDAL();
            string sqlQuery = "EXEC spContentUpload '" + objAirtelModel.ExcelFileName + "','" + objAirtelModel.ContentDate + "',N'"
                              + objAirtelModel.ContentText + "','" + objAirtelModel.ContentMonth + "','" + objAirtelModel.SheetName + "'";

            objDAL.ExecuteQuery(sqlQuery, KeyConstant.Server_Sahbox_17);
        }
Пример #12
0
        private void ContentUpAirtelHorosCope(DataTable dt, int Rows, string strExcelFileName)
        {
            clsDAL      objDAL;
            AirtelModel objAirtelModel = new AirtelModel();

            objAirtelModel.ExcelFileName = strExcelFileName;
            objAirtelModel.ContentDate   = Convert.ToDateTime(dt.Rows[Rows]["Date"].ToString()).ToString("MM/dd/yyyy");
            objAirtelModel.HorosCopeCode = dt.Rows[Rows]["Do Not Touch These Columns (B,C,D,E,F)"].ToString().Replace("'", null);
            objAirtelModel.HorosCopeName = dt.Rows[Rows]["F3"].ToString().Replace("'", null);
            objAirtelModel.ContentText   = dt.Rows[Rows]["F4"].ToString().Replace("'", null);
            objAirtelModel.ContentMonth  = ContentMonth(objAirtelModel.ContentDate);
            objAirtelModel.SheetName     = TableNameFormat(dt.TableName.ToString());

            objDAL = new clsDAL();
            string sqlQuery = "EXEC spContentUploadAirtelHoroscope '" + objAirtelModel.ExcelFileName + "','" + objAirtelModel.ContentDate
                              + "','" + objAirtelModel.HorosCopeCode + "','" + objAirtelModel.HorosCopeName + "',N'" + objAirtelModel.ContentText
                              + "','" + objAirtelModel.ContentMonth + "','" + objAirtelModel.SheetName + "'";

            objDAL.ExecuteQuery(sqlQuery, KeyConstant.Server_Sahbox_17);
        }
Пример #13
0
    protected void ImageButton1_Click1(object sender, ImageClickEventArgs e)
    {
        clsregistration objreg = new clsregistration();

        objreg.EmailID  = txtadminemailid.Text;
        objreg.Password = txtadminpassword.Text;
        //SqlConnection con = new SqlConnection();
        //cn.Open();
        clsDAL     clsdal = new clsDAL();
        String     q      = "Select * from tbladmin where User_Name ='" + txtadminemailid.Text + "'and Password='******'";
        SqlCommand com    = new SqlCommand(q);

        DataSet   ds = clsDAL.getData(q);
        DataTable dt = ds.Tables[0];

        if (dt.Rows.Count == 1)
        {
            Response.Redirect("~/Default.aspx");
        }
        else
        {
            lblmessage.Text = ("Please Enter Valid User_Name or Password");
        }
    }
        public string iscourseopenedBLL(UserBO ob)
        {
            clsDAL obj = new clsDAL();

            return(obj.iscourseopened(ob));
        }
        public void onupdateQuantifierBLL(UserBO ob)
        {
            clsDAL obj = new clsDAL();

            obj.onupdateQuantifier(ob);
        }
        public string firstnamerBLL(string s)
        {
            clsDAL obj = new clsDAL();

            return(obj.firstnamer(s));
        }
        public DataTable getCoursesofSkillBLL(UserBO ob)
        {
            clsDAL ob4 = new clsDAL();

            return(ob4.getCoursesofSkill(ob));
        }
        public DataTable QuestionTableCreatorBLL(UserBO o)
        {
            clsDAL obj = new clsDAL();

            return(obj.QuestionTableCreator(o));
        }
Пример #19
0
 public string Login(string email, string password)
 {
     clsDAL objDAL = new clsDAL();
     return objDAL.checkLogin(email, password).ToJSON();
 }
        public int AdminBuilderBLL(UserBO ob)
        {
            clsDAL ob13 = new clsDAL();

            return(ob13.AdminBuilder(ob));
        }
Пример #21
0
        public string SignUp()
        {
            //Retrieve POST data
            string jsonUserDetail = Request.Content.ReadAsStringAsync().Result;

            clsDAL objDAL = new clsDAL();
            return objDAL.signUp(jsonUserDetail).ToJSON();
        }
        public int isregisteredBLL(UserBO ob)
        {
            clsDAL obj = new clsDAL();

            return(obj.isregistered(ob));
        }
        public int AdminCounterBLL()
        {
            clsDAL ob1 = new clsDAL();

            return(ob1.AdminCounterDAL().Tables[0].Rows.Count);
        }
        public int FindUserTypeBLL(UserBO ob)
        {
            clsDAL ob1 = new clsDAL();

            return(ob1.FindUserType(ob));
        }
        public DataTable UserIDSearcherBLL(UserBO ob)
        {
            clsDAL obj = new clsDAL();

            return(obj.UserIDSearcher(ob));
        }
        public void updateStatusBLL(UserBO ob)
        {
            clsDAL obj = new clsDAL();

            obj.updateStatus(ob);
        }
        public void onregistrationcourseBLL(UserBO ob)
        {
            clsDAL obj = new clsDAL();

            obj.onregistrationcourse(ob);
        }
        public int InsertSkillBLL(UserBO ob)
        {
            clsDAL ob4 = new clsDAL();

            return(ob4.InsertSkill(ob));
        }
Пример #29
0
        public string PostingFileUpload()
        {
            //Retrieve POST data
            string jsonPostingDetail = Request.Content.ReadAsStringAsync().Result;

            clsDAL objDAL = new clsDAL();
            return objDAL.postingFileUpload(jsonPostingDetail).ToJSON();
        }
        public int SkillVerifyBLL(UserBO ob)
        {
            clsDAL ob4 = new clsDAL();

            return(ob4.SkillVerify(ob));
        }
        public int scorecardBLL(UserBO ob)
        {
            clsDAL obj = new clsDAL();

            return(obj.scorecard(ob));
        }
        public string SkillSearchBLL(UserBO ob)
        {
            clsDAL ob4 = new clsDAL();

            return(ob4.SkillSearch(ob));
        }
        public int updatetheQuestionBLL(UserBO s)
        {
            clsDAL obj = new clsDAL();

            return(obj.updatetheQuestion(s));
        }
        public DataTable SkillSearchTableBLL(UserBO ob)
        {
            clsDAL ob4 = new clsDAL();

            return(ob4.SkillSearchTable(ob));
        }
        public int VerifyUserIDBLL(UserBO ob2)
        {
            clsDAL ob1 = new clsDAL();

            return(ob1.VerifyUserID(ob2));
        }
        public void activateStatusBLL(UserBO ob)
        {
            clsDAL obj = new clsDAL();

            obj.activateStatus(ob);
        }