public int delete(int id)
{
AbstractCommonData entity = new UsersReplyEntity();
string delQuery = "delete from" + entity.TableName + " where " + entity.IndexFieldName + "=" + provider.getSQLString(id);
return(provider.delete(delQuery));
}
private void btnSave_Click(object sender, EventArgs e)
{
UsersReplyEntity entity = new UsersReplyEntity();
DataRow dr = entity.Tables[entity.TableName].NewRow();
dr[UsersReplyEntity.FIELD_ID] = _id;
dr[UsersReplyEntity.FIELD_USERID] = _userId;
dr[UsersReplyEntity.FIELD_LETTERID] = _letterId;
dr[UsersReplyEntity.FIELD_RESPONSEDATE] = DateTime.Now;
dr[UsersReplyEntity.FIELD_DESCRIPTION] = txtDescription.Text;
entity.Tables[entity.TableName].Rows.Add(dr);
if (_mode.Equals(Constants.ADD_MODE))
{
_id = _usersReplyBL.add(entity);
lblMsg.Text = "دخیره گردید";
_mode = Constants.EDIT_MODE;
this.Close();
}
else
{
_usersReplyBL.update(entity);
lblMsg.Text = "تغییرات به روز رسانی گردید";
}
}
public UsersReplyEntity getById(int id)
{
UsersReplyEntity entity = new UsersReplyEntity();
string cond = UsersReplyEntity.FIELD_ID + "=" + provider.getSQLString(id);
provider.loadToDataSet(entity, cond);
return(entity);
}
public UsersReplyEntity get(int letterid)
{
UsersReplyEntity entity = new UsersReplyEntity();
string cond = UsersReplyEntity.FIELD_LETTERID + "=" + provider.getSQLString(letterid);
provider.loadToDataSet(entity, cond);
return(entity);
}
public int finalizeReply(int letterid, int userid)
{
AbstractCommonData entity = new UsersReplyEntity();
string update = "UPDATE " + entity.TableName + " SET " + UsersReplyEntity.FIELD_FINALIZED + "=" +
provider.getSQLString(true)
+ " WHERE " + UsersReplyEntity.FIELD_LETTERID + "=" + provider.getSQLString(letterid) + " AND " +
UsersReplyEntity.FIELD_USERID + "=" + provider.getSQLString(userid);
return(provider.delete(update));
}
public UsersReplyForm(int id)
{
_id = id;
InitializeComponent();
_usersReplyBL = new UsersRelpyBL();
_mode = Constants.EDIT_MODE;
UsersReplyEntity entity = _usersReplyBL.getById(_id);
_userId = int.Parse(entity.get(UsersReplyEntity.FIELD_USERID).ToString());
_letterId = int.Parse(entity.get(UsersReplyEntity.FIELD_LETTERID).ToString());
txtRegisterDate.Text = RMX_TOOLS.date.DateXFormer.gregorianToPersianString((DateTime)
entity.get(UsersReplyEntity.FIELD_RESPONSEDATE));
txtDescription.Text = entity.get(UsersReplyEntity.FIELD_DESCRIPTION).ToString();
}
public int update(UsersReplyEntity entity)
{
return(provider.update(entity));
}
public int add(UsersReplyEntity entity)
{
return(provider.add(entity));
}
public int update(UsersReplyEntity entity)
{
return(((UsersReplyDA)_abstractDA).update(entity));
}
public int add(UsersReplyEntity entity)
{
return(((UsersReplyDA)_abstractDA).add(entity));
}