public int CheckUserName(ListDictionary Params) //קבלת רשימת פרמטרים
{
DBCtrl db_ctrl = new DBCtrl();
if (!db_ctrl.isConnected())
{
db_ctrl.connectToDb(connStr);
}
string sp_name = "CheckUserName"; //שם הפרוצדורה
return(db_ctrl.ExecuteNonQueryFunction(connStr, sp_name, ref Params)); //החזרת תוצאה
}
public int addReceipt(ListDictionary Params, string spName)
{
DBCtrl db_ctrl = new DBCtrl();
if (!db_ctrl.isConnected())
{
db_ctrl.connectToDb(connStr);
}
string sp_name = spName; //stored procedure name for execute
return(db_ctrl.ExecuteNonQueryFunction(connStr, sp_name, ref Params)); //execute the sp
}
public int Cheak_JobUser(ListDictionary Params)
{
DBCtrl DW_ctrl = new DBCtrl();
if (!DW_ctrl.isConnected())
{
DW_ctrl.connectToDb(connStr);
}
string sp_name = "Cheak_JobUser";
return(DW_ctrl.ExecuteNonQueryFunction(connStr, sp_name, ref Params)); //החזרת תוצאה
}
public int addOrUpdateLifeStyleNutritionist(ListDictionary Params) //קבלת רשימת פרמטרים
{
DBCtrl db_ctrl = new DBCtrl();
if (!db_ctrl.isConnected())
{
db_ctrl.connectToDb(connStr);
}
string sp_name = "addOrUpdateLifeStyleNutritionist"; //שם הפרוצדורה
return(db_ctrl.ExecuteNonQueryFunction(connStr, sp_name, ref Params)); //החזרת תוצאה
}