public static bool Authenticate(string EmailID, string Password)
{
SQLDBAccess db = new SQLDBAccess("CIPMS");
db.AddParameter("@EmailID", EmailID);
db.AddParameter("@Password", Password);
IDataReader dr = db.ExecuteReader("usp_ValidateLogin");
return(dr.Read());
}
public static Dictionary <string, string> GetFederationByIdOrZipCode(string zipCode, int fedId)
{
var db = new SQLDBAccess("CIPConnectionString");
db.AddParameter("@Action", "GetFedByZipCode");
if (fedId == 0)
{
db.AddParameter("@ZipCode", zipCode);
}
else
{
db.AddParameter("@FedID", fedId);
}
var dr = db.ExecuteReader("usprsFederations_Select");
var ret = new Dictionary <string, string>();
if (dr.Read())
{
ret.Add("ID", dr["ID"].ToString());
ret.Add("Name", dr["Name"].ToString());
ret.Add("Contact", dr["Contact"].ToString());
ret.Add("Phone", dr["Phone"].ToString());
ret.Add("Email", dr["Email"].ToString());
ret.Add("isActive", dr["isActive"].ToString());
ret.Add("isGrantAvailable", dr["isGrantAvailable"].ToString());
ret.Add("isOnlineProcessing", dr["isOnlineProcessing"].ToString());
ret.Add("isJDSAvailable", dr["isJDSAvailable"].ToString());
ret.Add("isJDSOnline", dr["isJDSOnline"].ToString());
ret.Add("is19DaysOnly", dr["is19DaysOnly"].ToString());
}
if (dr.Read())
{
if (!ret.ContainsKey("Error"))
{
ret.Add("Error", "Duplicate");
}
ret.Add("NameForSecondProgram", dr["Name"].ToString());
}
dr.Close();
return(ret);
}
public static int GetPaymentAccessFedID(DateTime myDate)
{
var db = new SQLDBAccess("CIPConnectionString");
db.AddParameter("@Action", "GetFedIDByDate");
db.AddParameter("@MyDate", myDate);
var dr = db.ExecuteReader("usp_PaymentDate_Select");
int ret = 0;
if (dr.Read())
{
ret = (int)dr[0];
}
return(ret);
}
public static AppData GetAppLevelData()
{
SQLDBAccess db = new SQLDBAccess("CIPMS");
db.AddParameter("@Action", "GetAppData");
IDataReader dr = db.ExecuteReader("usprsCampYear_Select");
if (dr.Read())
{
var data = new AppData()
{
CampYear = Convert.ToInt32(dr["CampYear"]), CampYearID = Convert.ToInt32(dr["ID"])
};
return(data);
}
return(null);
}
