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();
}
public string ImageUpload()
{
//Retrieve POST data
string imageData = Request.Content.ReadAsStringAsync().Result;
clsDAL objDAL = new clsDAL();
return objDAL.imageUpload(imageData).ToJSON();
}
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);
}
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);
}
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));
}
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));
}
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));
}
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);
}
