public void GetBy(HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TKeys keys, ref System.Data.DataSet dataSet) { try { _dataObject.SelectByPrimaryKey(keys, ref dataSet); } catch (System.Exception ex) { throw Hepsa.Core.Exception.HandleException.ChangeExceptionLanguage(ex, this); } }
public void Delete(HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TKeys keys) { try { _dataObject.Delete(keys); } catch (System.Exception ex) { throw Hepsa.Core.Exception.HandleException.ChangeExceptionLanguage(ex, this); } }
public void SelectByPrimaryKey(HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TKeys businessObjectKey, ref System.Data.DataTable dataTable) { bool ControlConnection = !(this.ConnectionState == System.Data.ConnectionState.Open); SqlDataAdapter sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(this.Command); this.Command.CommandText = "[sp_LadeAssignmentCacelRequest_T_SelectByPrimaryKey]"; this.Command.CommandType = CommandType.StoredProcedure; try { this.Command.Parameters.Clear(); SqlParameter LadeAssignmentCancelRequestID_int = new SqlParameter(); LadeAssignmentCancelRequestID_int.ParameterName = "@LadeAssignmentCancelRequestID_int"; LadeAssignmentCancelRequestID_int.SqlDbType = SqlDbType.Int; LadeAssignmentCancelRequestID_int.Direction = ParameterDirection.Input; LadeAssignmentCancelRequestID_int.IsNullable = false; LadeAssignmentCancelRequestID_int.Value = businessObjectKey.LadeAssignmentCancelRequestID_int; this.Command.Parameters.Add(LadeAssignmentCancelRequestID_int); if (ControlConnection) { this.BeginTransaction(); } sqlDataAdapter.Fill(dataTable); if (ControlConnection) { this.Commit(); } } catch (System.Exception ex) { if (ControlConnection) { this.RollBack(); } throw ex; } }
public HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_T SelectByPrimaryKey(HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TKeys businessObjectKey) { bool ControlConnection = !(this.ConnectionState == System.Data.ConnectionState.Open); this.Command.CommandText = "[sp_LadeAssignmentCacelRequest_T_SelectByPrimaryKey]"; this.Command.CommandType = CommandType.StoredProcedure; try { this.Command.Parameters.Clear(); SqlParameter LadeAssignmentCancelRequestID_int = new SqlParameter(); LadeAssignmentCancelRequestID_int.ParameterName = "@LadeAssignmentCancelRequestID_int"; LadeAssignmentCancelRequestID_int.SqlDbType = SqlDbType.Int; LadeAssignmentCancelRequestID_int.Direction = ParameterDirection.Input; LadeAssignmentCancelRequestID_int.IsNullable = false; LadeAssignmentCancelRequestID_int.Value = businessObjectKey.LadeAssignmentCancelRequestID_int; this.Command.Parameters.Add(LadeAssignmentCancelRequestID_int); if (ControlConnection) { this.BeginTransaction(); } IDataReader dataReader = this.Command.ExecuteReader(); HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_T businessObject = new HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_T(); if (dataReader.Read()) { PopulateBusinessObjectFromReader(businessObject, dataReader); } else { businessObject = null; } if (dataReader.IsClosed == false) { dataReader.Close(); } if (ControlConnection) { this.Commit(); } return(businessObject); } catch (System.Exception ex) { if (ControlConnection) { this.RollBack(); } throw ex; } }
public void Update(HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_T businessObject, HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TKeys businessObjectKey) { bool ControlConnection = !(this.ConnectionState == System.Data.ConnectionState.Open); this.Command.CommandText = "[sp_LadeAssignmentCacelRequest_T_Update]"; this.Command.CommandType = CommandType.StoredProcedure; try { this.Command.Parameters.Clear(); SqlParameter ResuestDate_nvc = new SqlParameter(); ResuestDate_nvc.ParameterName = "@ResuestDate_nvc"; ResuestDate_nvc.SqlDbType = SqlDbType.NVarChar; ResuestDate_nvc.Direction = ParameterDirection.Input; ResuestDate_nvc.IsNullable = false; ResuestDate_nvc.Value = businessObject.ResuestDate_nvc; this.Command.Parameters.Add(ResuestDate_nvc); SqlParameter RequestTime_nvc = new SqlParameter(); RequestTime_nvc.ParameterName = "@RequestTime_nvc"; RequestTime_nvc.SqlDbType = SqlDbType.NVarChar; RequestTime_nvc.Direction = ParameterDirection.Input; RequestTime_nvc.IsNullable = false; RequestTime_nvc.Value = businessObject.RequestTime_nvc; this.Command.Parameters.Add(RequestTime_nvc); SqlParameter RequestUserName_nvc = new SqlParameter(); RequestUserName_nvc.ParameterName = "@RequestUserName_nvc"; RequestUserName_nvc.SqlDbType = SqlDbType.NVarChar; RequestUserName_nvc.Direction = ParameterDirection.Input; RequestUserName_nvc.IsNullable = false; RequestUserName_nvc.Value = businessObject.RequestUserName_nvc; this.Command.Parameters.Add(RequestUserName_nvc); SqlParameter AcceptedDate_nvc = new SqlParameter(); AcceptedDate_nvc.ParameterName = "@AcceptedDate_nvc"; AcceptedDate_nvc.SqlDbType = SqlDbType.NVarChar; AcceptedDate_nvc.Direction = ParameterDirection.Input; AcceptedDate_nvc.IsNullable = false; if (String.IsNullOrEmpty(businessObject.AcceptedDate_nvc)) { AcceptedDate_nvc.Value = DBNull.Value; } else { AcceptedDate_nvc.Value = businessObject.AcceptedDate_nvc; } this.Command.Parameters.Add(AcceptedDate_nvc); SqlParameter AcceptedTime_nvc = new SqlParameter(); AcceptedTime_nvc.ParameterName = "@AcceptedTime_nvc"; AcceptedTime_nvc.SqlDbType = SqlDbType.NVarChar; AcceptedTime_nvc.Direction = ParameterDirection.Input; AcceptedTime_nvc.IsNullable = true; if (String.IsNullOrEmpty(businessObject.AcceptedTime_nvc)) { AcceptedTime_nvc.Value = DBNull.Value; } else { AcceptedTime_nvc.Value = businessObject.AcceptedTime_nvc; } this.Command.Parameters.Add(AcceptedTime_nvc); SqlParameter AcceptedUserName_nvc = new SqlParameter(); AcceptedUserName_nvc.ParameterName = "@AcceptedUserName_nvc"; AcceptedUserName_nvc.SqlDbType = SqlDbType.NVarChar; AcceptedUserName_nvc.Direction = ParameterDirection.Input; AcceptedUserName_nvc.IsNullable = true; if (String.IsNullOrEmpty(businessObject.AcceptedUserName_nvc)) { AcceptedUserName_nvc.Value = DBNull.Value; } else { AcceptedUserName_nvc.Value = businessObject.AcceptedUserName_nvc; } this.Command.Parameters.Add(AcceptedUserName_nvc); SqlParameter Comment_nvc = new SqlParameter(); Comment_nvc.ParameterName = "@Comment_nvc"; Comment_nvc.SqlDbType = SqlDbType.NVarChar; Comment_nvc.Direction = ParameterDirection.Input; Comment_nvc.IsNullable = true; if (String.IsNullOrEmpty(businessObject.Comment_nvc)) { Comment_nvc.Value = DBNull.Value; } else { Comment_nvc.Value = businessObject.Comment_nvc; } this.Command.Parameters.Add(Comment_nvc); SqlParameter LadeAssignmentID_bint = new SqlParameter(); LadeAssignmentID_bint.ParameterName = "@LadeAssignmentID_bint"; LadeAssignmentID_bint.SqlDbType = SqlDbType.BigInt; LadeAssignmentID_bint.Direction = ParameterDirection.Input; LadeAssignmentID_bint.IsNullable = true; LadeAssignmentID_bint.Value = businessObject.LadeAssignmentID_bint; this.Command.Parameters.Add(LadeAssignmentID_bint); SqlParameter pk_LadeAssignmentCancelRequestID_int = new SqlParameter(); pk_LadeAssignmentCancelRequestID_int.ParameterName = "@pk_LadeAssignmentCancelRequestID_int"; pk_LadeAssignmentCancelRequestID_int.SqlDbType = SqlDbType.Int; pk_LadeAssignmentCancelRequestID_int.Direction = ParameterDirection.Input; pk_LadeAssignmentCancelRequestID_int.IsNullable = false; pk_LadeAssignmentCancelRequestID_int.Value = businessObjectKey.LadeAssignmentCancelRequestID_int; this.Command.Parameters.Add(pk_LadeAssignmentCancelRequestID_int); if (ControlConnection) { this.BeginTransaction(); } this.Command.ExecuteNonQuery(); if (ControlConnection) { this.Commit(); } } catch (System.Exception ex) { if (ControlConnection) { this.RollBack(); } throw ex; } }
public LadeAssignmentCacelRequestEntityForm(Hepsa.Core.PL.BaseEntityParentForm.enmState State, DataTable DataTable, HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TKeys Key, HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TKeys LadeAssignmentKey) : base(State, DataTable, Key) { InitializeComponent(); _LadeAssignmentKey = LadeAssignmentKey; }
private void DeleteButton_Click(object sender, EventArgs e) { HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TFactory LadeAssignmentCacelRequestFactory = new HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TFactory(); try { if (Hepsa.Core.Common.MessageBox.ConfirmDeleteMessage() == false) { return; } HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TFactory LadeAssignmentCacelRequest_TFactory = new HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TFactory(); HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TKeys LadeAssignmentCacelRequestKey = new HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TKeys(); LadeAssignmentCacelRequestKey.LadeAssignmentCancelRequestID_int = (Int32)LadeAssignmentCacelRequestGridView.CurrentRow.Cells["colLadeAssignmentCancelRequestID_int"].Value; LadeAssignmentCacelRequestFactory.Delete(LadeAssignmentCacelRequestKey); DataRow[] dr = ((DataTable)this.LadeAssignmentCacelRequestGridView.DataSource).Select(HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_T.LadeAssignmentCacelRequest_TField.LadeAssignmentCancelRequestID_int.ToString() + "='" + LadeAssignmentCacelRequestKey.LadeAssignmentCancelRequestID_int.ToString() + "'"); if (dr.Length > 0) { dr[0].Delete(); } ((DataTable)this.LadeAssignmentCacelRequestGridView.DataSource).AcceptChanges(); } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void EditButton_Click(object sender, EventArgs e) { HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TKeys LadeAssignmentCacelRequestKey = new HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TKeys(); LadeAssignmentCacelRequestKey.LadeAssignmentCancelRequestID_int = (Int32)this.LadeAssignmentCacelRequestGridView.CurrentRow.Cells["colLadeAssignmentCancelRequestID_int"].Value; HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TKeys LadeAssignmentKey = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TKeys(); LadeAssignmentKey.LadeAssignmentID_bint = (Int64?)this.LadeAssignmentGridView.CurrentRow.Cells[colLadeAssignmentID_bint.Name].Value; LadeAssignmentCacelRequestEntityForm LadeAssignmentCacelRequest = new LadeAssignmentCacelRequestEntityForm(BaseEntityForm1.enmState.Edit, (DataTable)this.LadeAssignmentCacelRequestGridView.DataSource, LadeAssignmentCacelRequestKey, LadeAssignmentKey); LadeAssignmentCacelRequest.ShowDialog(); }
public HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_T GetBy(HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TKeys keys) { try { return(_dataObject.SelectByPrimaryKey(keys)); } catch (System.Exception ex) { throw Hepsa.Core.Exception.HandleException.ChangeExceptionLanguage(ex, this); } }
public void Update(HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_T businessObject, HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TKeys businessObjectKey) { try { HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_T tmp = this.GetBy(businessObjectKey); List <string> Except = new List <string>(); if (businessObject.LadeAssignmentCancelRequestID_int == tmp.LadeAssignmentCancelRequestID_int) { Except.Add("UniqueLadeAssignmentCancelRequestID_int"); } if (businessObject.LadeAssignmentID_bint == tmp.LadeAssignmentID_bint) { Except.Add("UniqueLadeAssignmentID_bint"); } if (Except.Count > 0) { if (businessObject.IsValid(Hepsa.Core.Validation.ValidationExceptionType.Except, Except.ToArray()) == false) { throw new Hepsa.Core.Validation.InvalidBusinessObjectException(businessObject.BrokenRulesList().ToString()); } } else { if (businessObject.IsValid() == false) { throw new Hepsa.Core.Validation.InvalidBusinessObjectException(businessObject.BrokenRulesList().ToString()); } } _dataObject.Update(businessObject, businessObjectKey); } catch (System.Exception ex) { throw Hepsa.Core.Exception.HandleException.ChangeExceptionLanguage(ex, this); } }