public static dbo_RequisitionClearingClass Select_Record(String Clearing_No)
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
dbo_RequisitionClearingClass clsdbo_RequisitionClearing = new dbo_RequisitionClearingClass();
SqlConnection connection = SAMDataClass.GetConnection();
string selectProcedure = "[RequisitionClearingSelect]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@Clearing_No", Clearing_No);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_RequisitionClearing.Clearing_No = reader["Clearing_No"] is DBNull ? null : reader["Clearing_No"].ToString();
clsdbo_RequisitionClearing.Requisition_No = reader["Requisition_No"] is DBNull ? null : reader["Requisition_No"].ToString();
clsdbo_RequisitionClearing.Clearing_Date = reader["Clearing_Date"] is DBNull ? null : (DateTime?)reader["Clearing_Date"];
clsdbo_RequisitionClearing.User_ID = reader["User_ID"] is DBNull ? null : reader["User_ID"].ToString();
}
else
{
clsdbo_RequisitionClearing = null;
}
reader.Close();
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(clsdbo_RequisitionClearing);
}
finally
{
connection.Close();
}
return(clsdbo_RequisitionClearing);
}
public static bool Update(dbo_RequisitionClearingClass olddbo_RequisitionClearingClass,
dbo_RequisitionClearingClass newdbo_RequisitionClearingClass)
{
SqlConnection connection = SAMDataClass.GetConnection();
string updateProcedure = "[dbo].[RequisitionClearingUpdate]";
SqlCommand updateCommand = new SqlCommand(updateProcedure, connection);
updateCommand.CommandType = CommandType.StoredProcedure;
if (newdbo_RequisitionClearingClass.Clearing_No != null)
{
updateCommand.Parameters.AddWithValue("@NewClearing_No", newdbo_RequisitionClearingClass.Clearing_No);
}
else
{
updateCommand.Parameters.AddWithValue("@NewClearing_No", DBNull.Value);
}
if (newdbo_RequisitionClearingClass.Requisition_No != null)
{
updateCommand.Parameters.AddWithValue("@NewRequisition_No", newdbo_RequisitionClearingClass.Requisition_No);
}
else
{
updateCommand.Parameters.AddWithValue("@NewRequisition_No", DBNull.Value);
}
if (olddbo_RequisitionClearingClass.Clearing_No != null)
{
updateCommand.Parameters.AddWithValue("@OldClearing_No", olddbo_RequisitionClearingClass.Clearing_No);
}
else
{
updateCommand.Parameters.AddWithValue("@OldClearing_No", DBNull.Value);
}
if (olddbo_RequisitionClearingClass.Requisition_No != null)
{
updateCommand.Parameters.AddWithValue("@OldRequisition_No", olddbo_RequisitionClearingClass.Requisition_No);
}
else
{
updateCommand.Parameters.AddWithValue("@OldRequisition_No", DBNull.Value);
}
updateCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int);
updateCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
try
{
connection.Open();
updateCommand.ExecuteNonQuery();
int count = System.Convert.ToInt32(updateCommand.Parameters["@ReturnValue"].Value);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(false);
}
finally
{
connection.Close();
}
}
public static bool Add(dbo_RequisitionClearingClass clsdbo_RequisitionClearing)
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
SqlConnection connection = SAMDataClass.GetConnection();
string insertProcedure = "[RequisitionClearingInsert]";
SqlCommand insertCommand = new SqlCommand(insertProcedure, connection);
insertCommand.CommandType = CommandType.StoredProcedure;
if (clsdbo_RequisitionClearing.Clearing_No != null)
{
insertCommand.Parameters.AddWithValue("@Clearing_No", clsdbo_RequisitionClearing.Clearing_No);
}
else
{
insertCommand.Parameters.AddWithValue("@Clearing_No", DBNull.Value);
}
if (clsdbo_RequisitionClearing.Requisition_No != null)
{
insertCommand.Parameters.AddWithValue("@Requisition_No", clsdbo_RequisitionClearing.Requisition_No);
}
else
{
insertCommand.Parameters.AddWithValue("@Requisition_No", DBNull.Value);
}
if (clsdbo_RequisitionClearing.User_ID != null)
{
insertCommand.Parameters.AddWithValue("@User_ID", clsdbo_RequisitionClearing.User_ID);
}
else
{
insertCommand.Parameters.AddWithValue("@User_ID", DBNull.Value);
}
insertCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int);
insertCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
try
{
connection.Open();
insertCommand.ExecuteNonQuery();
int count = System.Convert.ToInt32(insertCommand.Parameters["@ReturnValue"].Value);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(false);
}
finally
{
connection.Close();
}
}
