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);
}
