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)); //החזרת תוצאה }