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