public bool UpdateData(string userID, ArrayList arrData) { bool ret = true; OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { for (int i = 0; i < arrData.Count; ++i) { ProductStockAdjustData data = (ProductStockAdjustData)arrData[i]; DALObj.GetDataByLOID(data.LOID, obj.zTrans); DALObj.QTY = data.QTY; if (DALObj.OnDB) ret = DALObj.UpdateCurrentData(userID, obj.zTrans); if (!ret) throw new ApplicationException(DALObj.ErrorMessage); } obj.zTrans.Commit(); obj.zConn.Close(); } catch (Exception ex) { ret = false; _error = ex.Message; obj.zTrans.Rollback(); obj.zConn.Close(); } return ret; }
public bool UpdateData(string userID, double loid, double qty) { bool ret = true; OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { DALObj.GetDataByLOID(loid, obj.zTrans); DALObj.QTY = qty; if (DALObj.OnDB) ret = DALObj.UpdateCurrentData(userID, obj.zTrans); if (!ret) throw new ApplicationException(DALObj.ErrorMessage); obj.zTrans.Commit(); obj.zConn.Close(); } catch (Exception ex) { ret = false; _error = ex.Message; obj.zTrans.Rollback(); obj.zConn.Close(); } return ret; }
public bool UpdateData(string userID, SysConfigData data) { bool ret = true; if (ValidateData(data)) { OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { DALObj.GetDataByLOID(data.LOID, obj.zTrans); DALObj.CONFIGNAME = data.CONFIGNAME.Trim(); DALObj.CONFIGVALUE = data.CONFIGVALUE; DALObj.DESCRIPTION = data.DESCRIPTION.Trim(); if (DALObj.OnDB) ret = DALObj.UpdateCurrentData(userID, obj.zTrans); else ret = DALObj.InsertCurrentData(userID, obj.zTrans); if (!ret) { throw new ApplicationException(DALObj.ErrorMessage); } obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } } else ret = false; return ret; }
public bool ChangePassword(double officerID, string newPassword) { bool ret = true; OfficerDAL offDAL = new OfficerDAL(); OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { offDAL.GetDataByLOID(officerID, obj.zTrans); offDAL.PASSWORD = Encrypt(newPassword); if (offDAL.OnDB) offDAL.UpdateCurrentData(offDAL.USERID, obj.zTrans); else throw new ApplicationException("��辺�����Ţͧ��ҹ��к�"); obj.zTrans.Commit(); obj.zConn.Close(); } catch (Exception ex) { ret = false; _error = ex.Message; obj.zTrans.Rollback(); obj.zConn.Close(); } return ret; }
public bool UpdateData(string userID, OfficerData data) { bool ret = true; if (VeridateData(data)) { OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { SearchDAL.OnDB = false; SearchDAL.GetDataByLOID(data.LOID, obj.zTrans); SearchDAL.TNAME = data.TNAME.Trim(); SearchDAL.LASTNAME = data.LASTNAME.Trim(); SearchDAL.DIVISION = data.DIVISION; SearchDAL.USERID = data.USERID; SearchDAL.PASSWORD = AppFlow.Encrypt(data.PASSWORD); SearchDAL.EFDATE = data.EFDATE; SearchDAL.NICKNAME = data.NICKNAME; SearchDAL.BIRTHDATE = data.BIRTHDATE; SearchDAL.TEL = data.TEL; SearchDAL.EMAIL = data.EMAIL; SearchDAL.ADDRESS = data.ADDRESS; SearchDAL.ROAD = data.ROAD; SearchDAL.PROVINCE = data.PROVINCE; SearchDAL.AMPHUR = data.AMPHUR; SearchDAL.TAMBOL = data.TAMBOL; SearchDAL.ZIPCODE = data.ZIPCODE; SearchDAL.REMARK = data.REMARK; SearchDAL.TITLE = data.TITLE; if (SearchDAL.OnDB) ret = SearchDAL.UpdateCurrentData(userID, obj.zTrans); else ret = SearchDAL.InsertCurrentData(userID, obj.zTrans); _LOID = SearchDAL.LOID; if (ret) { obj.zTrans.Commit(); obj.CloseConnection(); } else { _error = SearchDAL.ErrorMessage; } } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; throw new ApplicationException(ex.Message); } } else ret = false; return ret; }
public bool DeleteData(ArrayList arrData) { bool ret = true; OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { OfficerPositionDAL opDAL = new OfficerPositionDAL(); for (int i = 0; i < arrData.Count; i++) { SearchDAL.GetDataByLOID(Convert.ToDouble(arrData[i]), obj.zTrans); opDAL.DeleteDataByOfficer(Convert.ToDouble(arrData[i]), obj.zTrans); ret = SearchDAL.DeleteCurrentData(obj.zTrans); if (!ret) { throw new ApplicationException(SearchDAL.ErrorMessage); } } obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } return ret; }