private AddBranch CreateObject(NullHandler oReader) { AddBranch oAddBranch = new AddBranch(); MapObject(oAddBranch, oReader); return(oAddBranch); }
private void MapObject(AddBranch oAddBranch, NullHandler oReader) { BusinessObject.Factory.SetID(oAddBranch, new ID(oReader.GetInt32("brn_id"))); oAddBranch.ebrn_type = (EnumBrnchType)oReader.GetInt32("brn_type"); oAddBranch.brn_title = oReader.GetString("brn_title"); oAddBranch.brn_location = oReader.GetString("brn_location"); BusinessObject.Factory.SetObjectState(oAddBranch, ObjectState.Saved); }
private AddBranchs CreateObjects(IDataReader oReader) { AddBranchs oAddBranchs = new AddBranchs(); NullHandler oHandler = new NullHandler(oReader); while (oReader.Read()) { AddBranch oItem = CreateObject(oHandler); oAddBranchs.Add(oItem); } return(oAddBranchs); }
public bool UpdateBranch(AddBranch oAddBranch, int nBrnID) { try { string QueryString = "UPDATE tbl_Branchs SET " + "brn_type=" + (int)oAddBranch.ebrn_type + "," + "brn_title='" + oAddBranch.brn_title + "'," + "brn_location='" + oAddBranch.brn_location + "'," + "DBUserID=" + EMSGlobal._nCurrentUserID + "," + "DBSDT='" + DateTime.Now + "' " + "WHERE brn_id=" + nBrnID + ""; ExecuteQueryFunctions.ExeNonQuery(_conn, QueryString); return(true); } catch (Exception e) { throw new ServiceException(e.Message, e); } }
public ID Save(AddBranch oAddBranch) { bool _isBranchExist = false; try { if (oAddBranch.IsNew) { string QueryString = "SELECT * FROM tbl_Branchs WHERE brn_title='" + oAddBranch.brn_title + "'"; _isBranchExist = ExecuteQueryFunctions.ExeIsExist(QueryString); if (!_isBranchExist) { BusinessObject.Factory.SetID(oAddBranch, new ID(ExecuteQueryFunctions.GetNewID(_conn, "SELECT MAX(brn_id) FROM tbl_Branchs"))); string QueryString2 = "INSERT INTO tbl_Branchs (brn_id,brn_type,brn_title,brn_location,DBUserID,DBSDT)" + "VALUES(" + oAddBranch.ObjectID + "," + (int)oAddBranch.ebrn_type + ",'" + oAddBranch.brn_title + "','" + oAddBranch.brn_location + "'," + EMSGlobal._nCurrentUserID + ",'" + DateTime.Now + "')"; ExecuteQueryFunctions.ExeNonQuery(_conn, QueryString2); } else { throw new ServiceException("This Title Already Exist."); } } BusinessObject.Factory.SetObjectState(oAddBranch, ObjectState.Saved); } catch (Exception e) { throw new ServiceException(e.Message, e); } return(oAddBranch.ID); }
public AddBranch Get(int nID) { AddBranch oAddBranch = new AddBranch(); try { string QueryString = "SELECT * FROM tbl_Branchs WHERE brn_id=" + nID; IDataReader reader = ExecuteQueryFunctions.ExeReader(_conn, QueryString); NullHandler oReader = new NullHandler(reader); if (reader.Read()) { oAddBranch = CreateObject(oReader); } reader.Close(); _conn.Close(); } catch (Exception e) { throw new ServiceException("Failed to Get AddBranch", e); } return(oAddBranch); }
public void OnAddBranch() { AddBranch?.Invoke(this); }