private bool UpdateGetPassDetails(GetPass getPass, Database db, DbTransaction transaction) { bool result = false; try { DbCommand insCommand = db.GetStoredProcCommand(Constant.SP_GetPas_Add_Details); db.AddInParameter(insCommand, "@biGPId", DbType.Int64, getPass.GPId); db.AddInParameter(insCommand, "@biInvDetID", DbType.Int64, "InvDetID", DataRowVersion.Current); db.AddInParameter(insCommand, "@biQty", DbType.Int64, "Qty", DataRowVersion.Current); DbCommand delCommand = db.GetStoredProcCommand(Constant.SP_GetPass_Delete_GetPassDetails); db.AddInParameter(delCommand, "@biGPId", DbType.Int64, getPass.GPId); db.AddInParameter(delCommand, "@biInvDetID", DbType.Int64, "InvDetID", DataRowVersion.Current); db.AddInParameter(delCommand, "@biQty", DbType.Int64, "Qty", DataRowVersion.Current); db.UpdateDataSet(getPass.DsGatePassDetails, getPass.DsGatePassDetails.Tables[0].TableName, insCommand, null, delCommand, transaction); result = true; } catch (System.Exception ex) { result = false; throw ex; } return(result); }
public bool AddGetPass(GetPass getPass) { bool result = false; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); connection = db.CreateConnection(); connection.Open(); transaction = connection.BeginTransaction(); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_GetPass_Add); db.AddInParameter(cmd, "@sGPCode", DbType.String, getPass.GPCode); db.AddInParameter(cmd, "@iInvoiceId", DbType.Int32, getPass.InvoiceId); db.AddInParameter(cmd, "@iCreatedBy", DbType.Int32, getPass.CreatedBy); db.AddOutParameter(cmd, "@biGPId", DbType.Int64, 8); if (db.ExecuteNonQuery(cmd, transaction) > 0) { Int32 newGatePassID = Convert.ToInt32(db.GetParameterValue(cmd, "@biGPId")); if (newGatePassID > 0) { getPass.GPId = newGatePassID; if (this.UpdateGetPassDetails(getPass, db, transaction)) { transaction.Commit(); result = true; } } } } catch (System.Exception ex) { transaction.Rollback(); result = false; throw ex; } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } return(result); }
public bool AddGetPass(GetPass getPass) { bool result = false; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); connection = db.CreateConnection(); connection.Open(); transaction = connection.BeginTransaction(); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_GetPass_Add); db.AddInParameter(cmd, "@sGPCode", DbType.String, getPass.GPCode); db.AddInParameter(cmd, "@iInvoiceId", DbType.Int32, getPass.InvoiceId); db.AddInParameter(cmd, "@iCreatedBy", DbType.Int32, getPass.CreatedBy); db.AddOutParameter(cmd, "@biGPId", DbType.Int64, 8); if (db.ExecuteNonQuery(cmd, transaction) > 0) { Int32 newGatePassID = Convert.ToInt32(db.GetParameterValue(cmd, "@biGPId")); if (newGatePassID > 0) { getPass.GPId = newGatePassID; if (this.UpdateGetPassDetails(getPass, db, transaction)) { transaction.Commit(); result = true; } } } } catch (System.Exception ex) { transaction.Rollback(); result = false; throw ex; } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } return result; }
public bool UpdateGetPass(GetPass getPass) { bool result = false; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); connection = db.CreateConnection(); connection.Open(); transaction = connection.BeginTransaction(); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_GetPass_Update); db.AddInParameter(cmd, "@biGPId", DbType.Int64, getPass.GPId); db.AddInParameter(cmd, "@iModifiedBy", DbType.Int32, getPass.ModifiedBy); if (db.ExecuteNonQuery(cmd, transaction) > 0) { if (this.UpdateGetPassDetails(getPass, db, transaction)) { transaction.Commit(); result = true; } } } catch (System.Exception ex) { transaction.Rollback(); result = false; throw ex; } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } return(result); }
public DataSet GetGetPassDetailsByID(GetPass getPass) { DataSet ds = null; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_GetPass_Get_DetailsByID); db.AddInParameter(cmd, "@biGPId", DbType.Int64, getPass.GPId); ds = db.ExecuteDataSet(cmd); } catch (System.Exception ex) { ds = null; throw ex; } return(ds); }
public bool GetGetPassByID(GetPass getPass) { bool result = false; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_GetPass_Get_ByID); db.AddInParameter(cmd, "@biGPId", DbType.Int64, getPass.GPId); IDataReader reader = db.ExecuteReader(cmd); if (reader != null) { while (reader.Read()) { getPass.GPId = reader["GPId"] != DBNull.Value ? Convert.ToInt64(reader["GPId"].ToString()) : 0; getPass.GPCode = reader["GPCode"] != DBNull.Value ? Convert.ToString(reader["GPCode"].ToString()) : string.Empty; getPass.InvoiceId = reader["InvoiceId"] != DBNull.Value ? Convert.ToInt32(reader["InvoiceId"].ToString()) : 0; getPass.InvoiceNo = reader["InvoiceNo"] != DBNull.Value ? Convert.ToString(reader["InvoiceNo"].ToString()) : string.Empty; getPass.InvoiceAmmount = reader["GrandTotal"] != DBNull.Value ? Convert.ToDecimal(reader["GrandTotal"].ToString()) : 0; getPass.CreatedBy = reader["CreatedBy"] != DBNull.Value ? Convert.ToInt32(reader["CreatedBy"].ToString()) : 0; getPass.CreatedDate = reader["CreatedDate"] != DBNull.Value ? Convert.ToDateTime(reader["CreatedDate"].ToString()) : DateTime.MinValue; getPass.ModifiedBy = reader["ModifiedBy"] != DBNull.Value ? Convert.ToInt32(reader["ModifiedBy"].ToString()) : 0; getPass.ModifiedDate = reader["ModifiedDate"] != DBNull.Value ? Convert.ToDateTime(reader["ModifiedDate"].ToString()) : DateTime.MinValue; getPass.DsGatePassDetails = this.GetGetPassDetailsByID(getPass); result = true; } } } catch (System.Exception ex) { throw ex; } return(result); }
public bool GetGetPassByCode(GetPass getPass) { bool result = false; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_GetPass_GetByCode); db.AddInParameter(cmd, "@sGPCode", DbType.String, getPass.GPCode); IDataReader reader = db.ExecuteReader(cmd); if (reader != null) { while (reader.Read()) { getPass.GPId = reader["GPId"] != DBNull.Value ? Convert.ToInt64(reader["GPId"].ToString()) : 0; getPass.GPCode = reader["GPCode"] != DBNull.Value ? Convert.ToString(reader["GPCode"].ToString()) : string.Empty; getPass.InvoiceId = reader["InvoiceId"] != DBNull.Value ? Convert.ToInt32(reader["InvoiceId"].ToString()) : 0; getPass.CreatedBy = reader["CreatedBy"] != DBNull.Value ? Convert.ToInt32(reader["CreatedBy"].ToString()) : 0; getPass.CreatedDate = reader["CreatedDate"] != DBNull.Value ? Convert.ToDateTime(reader["CreatedDate"].ToString()) : DateTime.MinValue; getPass.ModifiedBy = reader["ModifiedBy"] != DBNull.Value ? Convert.ToInt32(reader["ModifiedBy"].ToString()) : 0; getPass.ModifiedDate = reader["ModifiedDate"] != DBNull.Value ? Convert.ToDateTime(reader["ModifiedDate"].ToString()) : DateTime.MinValue; getPass.DsGatePassDetails = this.GetGetPassDetailsByID(getPass); result = true; } } } catch (System.Exception ex) { throw ex; } return result; }
private bool UpdateGetPassDetails(GetPass getPass, Database db, DbTransaction transaction) { bool result = false; try { DbCommand insCommand = db.GetStoredProcCommand(Constant.SP_GetPas_Add_Details); db.AddInParameter(insCommand, "@biGPId", DbType.Int64, getPass.GPId); db.AddInParameter(insCommand, "@biInvDetID", DbType.Int64, "InvDetID", DataRowVersion.Current); db.AddInParameter(insCommand, "@biQty", DbType.Int64, "Qty", DataRowVersion.Current); DbCommand delCommand = db.GetStoredProcCommand(Constant.SP_GetPass_Delete_GetPassDetails); db.AddInParameter(delCommand, "@biGPId", DbType.Int64, getPass.GPId); db.AddInParameter(delCommand, "@biInvDetID", DbType.Int64, "InvDetID", DataRowVersion.Current); db.AddInParameter(delCommand, "@biQty", DbType.Int64, "Qty", DataRowVersion.Current); db.UpdateDataSet(getPass.DsGatePassDetails, getPass.DsGatePassDetails.Tables[0].TableName, insCommand, null, delCommand, transaction); result = true; } catch (System.Exception ex) { result = false; throw ex; } return result; }
public bool UpdateGetPass(GetPass getPass) { bool result = false; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); connection = db.CreateConnection(); connection.Open(); transaction = connection.BeginTransaction(); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_GetPass_Update); db.AddInParameter(cmd, "@biGPId", DbType.Int64, getPass.GPId); db.AddInParameter(cmd, "@iModifiedBy", DbType.Int32, getPass.ModifiedBy); if (db.ExecuteNonQuery(cmd, transaction) > 0) { if (this.UpdateGetPassDetails(getPass, db, transaction)) { transaction.Commit(); result = true; } } } catch (System.Exception ex) { transaction.Rollback(); result = false; throw ex; } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } return result; }
public DataSet GetGetPassDetailsByID(GetPass getPass) { DataSet ds = null; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_GetPass_Get_DetailsByID); db.AddInParameter(cmd, "@biGPId", DbType.Int64, getPass.GPId); ds = db.ExecuteDataSet(cmd); } catch (System.Exception ex) { ds = null; throw ex; } return ds; }