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);
}
