public void INSERT_USER_DIST_PREDICTIONS(oAPCONSISTENCIES entities) { Database DB = DatabaseFactory.CreateDatabase(); DbCommand dbCom = DB.GetStoredProcCommand("USP_INSERT_USER_DIST_PREDICTIONS"); DB.AddInParameter(dbCom, "@DIST_ID", DbType.Int16, entities.Dist_id); DB.AddInParameter(dbCom, "@USER_EMAIL", DbType.String, entities.Useremail); DB.AddInParameter(dbCom, "@USER_PREDICTIONS", DbType.String, entities.Userpredicts); DB.AddInParameter(dbCom, "@SHORT_CODE", DbType.String, entities.Shot_code); DB.AddInParameter(dbCom, "@TDP", DbType.Int16, entities.Tdp_count); DB.AddInParameter(dbCom, "@YSRCP", DbType.Int16, entities.Ysrcp_count); DB.AddInParameter(dbCom, "@JANASENA", DbType.Int16, entities.Jsp_count); DB.AddInParameter(dbCom, "@BJP", DbType.Int16, entities.Bjp_count); DB.AddInParameter(dbCom, "@MAJORITY_COUNT", DbType.Int16, entities.Majority_count); DB.AddInParameter(dbCom, "@MAJORITY_COUNT_PARTY_NAME", DbType.String, entities.Majority_count_party_name); DB.AddInParameter(dbCom, "@QUERY_STATUS", DbType.String, "CHECK"); var rdr = DB.ExecuteReader(dbCom); if (rdr.Read()) { entities.Query_status = rdr["QUERY_STATUS"].ToString(); } rdr.Close(); DB.ExecuteNonQuery(dbCom); }
public void UserNameExists(string userName) { bool userNameInUse = false; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("CHECK_USER", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter() { ParameterName = "@email", Value = userName }); con.Open(); userNameInUse = Convert.ToBoolean(cmd.ExecuteScalar()); } oAPCONSISTENCIES entities = new oAPCONSISTENCIES(); entities.Useremail = userName; entities.UserNameInUse = userNameInUse; JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Write(js.Serialize(entities)); }
public void UserPredicts(oAPCONSISTENCIES entities) { Database DB = DatabaseFactory.CreateDatabase(); DbCommand dbCom = DB.GetStoredProcCommand("USER_PREDICTS"); DB.AddInParameter(dbCom, "@U_EMAIL", DbType.String, entities.Useremail); DB.AddInParameter(dbCom, "@U_PREDICT", DbType.String, entities.Userpredicts); DB.ExecuteNonQuery(dbCom); }
public void UserPredicts(oAPCONSISTENCIES entities) { Database DB = DatabaseFactory.CreateDatabase(); DbCommand dbCom = DB.GetStoredProcCommand("USER_PREDICTS_SAVING"); DB.AddInParameter(dbCom, "@USERID", DbType.Int32, entities.Userid); DB.AddInParameter(dbCom, "@USER_PREDICTIONS", DbType.String, entities.Userpredicts); DB.AddInParameter(dbCom, "@DIST_ID", DbType.Int32, entities.Dist_id); DB.ExecuteNonQuery(dbCom); }
public void dIstpredicts_duplicate(oAPCONSISTENCIES entities) { Database DB = DatabaseFactory.CreateDatabase(); DbCommand dbCom = DB.GetStoredProcCommand("INSERT_US_PRED_DIST_DUPLICATES"); DB.AddInParameter(dbCom, "@U_EMAIL", DbType.String, entities.Useremail); DB.AddInParameter(dbCom, "@U_PREDICTS", DbType.String, entities.Userpredicts); DB.AddInParameter(dbCom, "@SHORTCODE", DbType.String, entities.Shot_code); DB.AddInParameter(dbCom, "@DIST_ID", DbType.Int16, entities.Dist_id); DB.ExecuteNonQuery(dbCom); }
public void GET_USER_DIST_PREDICTIONS(oAPCONSISTENCIES entities) { Database DB = DatabaseFactory.CreateDatabase(); DbCommand dbCom = DB.GetStoredProcCommand("USP_GET_USER_DIST_PREDICTIONS"); DB.AddInParameter(dbCom, "@SHORT_CODE", DbType.String, entities.Shot_code); var rdr = DB.ExecuteReader(dbCom); if (rdr.Read()) { entities.Dist_id = int.Parse(rdr["DIST_ID"].ToString()); entities.Useremail = rdr["USER_EMAIL"].ToString(); entities.Userpredicts = rdr["USER_PREDICTIONS"].ToString(); } rdr.Close(); DB.ExecuteNonQuery(dbCom); }
public void INSERT_USERS(oAPCONSISTENCIES entities) { Database DB = DatabaseFactory.CreateDatabase(); DbCommand dbCom = DB.GetStoredProcCommand("USP_INSERT_USERS"); DB.AddInParameter(dbCom, "@U_EMAIL", DbType.String, entities.Useremail); DB.AddInParameter(dbCom, "@USER_PREDICTS", DbType.String, entities.Userpredicts); DB.AddInParameter(dbCom, "@SHOT_CODE", DbType.String, entities.Shot_code); DB.AddInParameter(dbCom, "@QUERY_STATUS", DbType.String, "CHECK"); var rdr = DB.ExecuteReader(dbCom); if (rdr.Read()) { entities.Query_status = rdr["QUERY_STATUS"].ToString(); } rdr.Close(); DB.ExecuteNonQuery(dbCom); }