//Type: 'SEARCH_STATE_SNO_BY_CITY_SNO
public int GetStateSNoByCity()
{
int intSno = 0;
SqlParameter[] sqlParamG =
{
new SqlParameter("@MessageOut", SqlDbType.NVarChar, 1000),
new SqlParameter("@Return_Value", SqlDbType.Int),
new SqlParameter("@City_Sno", int.Parse(this.City)),
new SqlParameter("@Type", this.Type)
};
sqlParamG[0].Direction = ParameterDirection.Output;
sqlParamG[1].Direction = ParameterDirection.ReturnValue;
// ---------- Added By Rajiv on 28-07-2010----------
// intSno = (int)objSql.ExecuteScalar(CommandType.StoredProcedure, "uspCallReg", sqlParamG);
Sp_Name = Get_Sp_Name(this.Type);
intSno = (int)objSql.ExecuteScalar(CommandType.StoredProcedure, Sp_Name, sqlParamG);
// Ended By Rajiv
this.ReturnValue = int.Parse(sqlParamG[1].Value.ToString());
if (int.Parse(sqlParamG[1].Value.ToString()) == -1)
{
this.MessageOut = sqlParamG[0].Value.ToString();
}
return(intSno);
}
public string getUserID(string UserName)
{
string result = string.Empty;
SqlParameter[] sqlParamM =
{
new SqlParameter("@UserName", UserName),
new SqlParameter("@Return", SqlDbType.VarChar, 50)
};
sqlParamM[1].Direction = ParameterDirection.Output;
objSql.ExecuteScalar(CommandType.StoredProcedure, "uspGetTVTUser", sqlParamM);
result = Convert.ToString(sqlParamM[1].Value);
return(result);
}
