private int getChequeRefferences(int userid) { ReferChequeBL bl = new ReferChequeBL(); ReferChequeEntity entity = bl.getByUserId(userid); return(entity.Tables[entity.FilledTableName].Rows.Count); }
public int delete(int id) { AbstractCommonData entity = new ReferChequeEntity(); string delQuery = "DELETE FROM " + entity.TableName + " WHERE " + ReferChequeEntity.indexField + "=" + provider.getSQLString(id); return(provider.delete(delQuery)); }
public ReferChequeEntity get(int chequeId) { ReferChequeEntity entity = new ReferChequeEntity(); string cond = ReferChequeEntity.FIELD_CHEQUE_ID + "=" + provider.getSQLString(chequeId); provider.loadToDataSet(entity, cond); return(entity); }
public ReferChequeEntity getByUserId(int userid) { ReferChequeEntity entity = new ReferChequeEntity(); string cond = ReferChequeEntity.FIELD_REFER_FROM_USER + "=" + provider.getSQLString(userid) + " OR " + ReferChequeEntity.FIELD_REFER_TO_USER + "=" + provider.getSQLString(userid); provider.loadToDataSet(entity, cond); return(entity); }
public void initForm(int chequeId) { ReferChequeBL refChequeBl = new ReferChequeBL(); ReferChequeEntity entity = refChequeBl.get(chequeId); System.Collections.Hashtable hash = new Hashtable(); hash.Add("colorField", "COLOR"); //_gridTools.bindDataToGrid(dataGridView1, entity, new GridTools.changingRow(_gridTools.changeColor), hash); _gridTools.bindDataToGrid(dataGridView1, entity, null, hash); }
public int removeUserRefer(int userid) { int i = 0; AbstractCommonData entity = new ReferChequeEntity(); string delQuery = "UPDATE " + entity.TableName + " SET " + ReferChequeEntity.FIELD_REFER_FROM_USER + "=" + provider.getSQLString(userid) + " WHERE " + ReferChequeEntity.FIELD_REFER_FROM_USER + "=" + provider.getSQLString(userid); i = provider.executeNonQuery(delQuery); delQuery = "UPDATE " + entity.TableName + " SET " + ReferChequeEntity.FIELD_REFER_TO_USER + "=" + provider.getSQLString(userid) + " WHERE " + ReferChequeEntity.FIELD_REFER_TO_USER + "=" + provider.getSQLString(userid); i += provider.executeNonQuery(delQuery); return(i); }
public int updateRefferenceUser(int chequeId, int userTreeId) { if (chequeId < 0) { return(0); } int referFromUserId = int.Parse(UsersBS.loginedUser.get(UsersEntity.FIELD_ID).ToString()); int updated = ((ChequeDA)_abstractDA).updateRefferenceUser(chequeId, userTreeId, referFromUserId); ReferChequeBL referChequeBL = new ReferChequeBL(); //Register Refer to refer cheque table int currUserId = int.Parse(UsersBS.loginedUser.get(UsersEntity.FIELD_ID).ToString()); // کاربری که در درخت قرار دارد را شناسایی کرده و // به userTreeUserId الحاق شود UserTreeBL userTreeBL = new UserTreeBL(); UserTreeEntity usertreeEntity = userTreeBL.get(userTreeId); int usertreeUserId = int.Parse(usertreeEntity.get(UserTreeEntity.FIELD_USER_ID).ToString()); ReferChequeEntity entity = new ReferChequeEntity(); DataRow dr = entity.Tables[entity.TableName].NewRow(); dr[ReferChequeEntity.FIELD_CHEQUE_ID] = chequeId; dr[ReferChequeEntity.FIELD_REFER_DATE] = DateTime.Now; dr[ReferChequeEntity.FIELD_REFER_FROM_USER] = currUserId; dr[ReferChequeEntity.FIELD_REFER_TO_USER] = usertreeUserId;// کاربر در درخت کاربران entity.Tables[entity.TableName].Rows.Add(dr); referChequeBL.add(entity); //check how many reffer occured this cheque // اگر بیش از حد ارجاع شده باشد رنگ ان را تغییر خواهیم داد int refCount = referChequeBL.getReferCount(chequeId); ApplicationPropertiesBL appProBl = new ApplicationPropertiesBL(); int masterRefCount = int.Parse(appProBl.getValue(ApplicationPropertiesBL.REFERENCE_COUNT)); if (refCount >= masterRefCount) { string refColor = appProBl.getValue(ApplicationPropertiesBL.COLOR_REFERENCE_LIMIT); updateColor(chequeId, refColor); } return(updated); }
public int update(ReferChequeEntity entity) { return(((ReferChequeDA)_abstractDA).update(entity)); }
public int add(ReferChequeEntity entity) { return(((ReferChequeDA)_abstractDA).add(entity)); }
public int update(ReferChequeEntity entity) { return(provider.update(entity)); }
public int add(ReferChequeEntity ChequeEntity) { return(provider.add(ChequeEntity)); }
public int getReferCount(int chequeId) { ReferChequeEntity entity = get(chequeId); return(entity.Tables[entity.FilledTableName].Rows.Count); }