public static dbo_OtherRequisitionClass Select_Record(String Requisition_No)
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
dbo_OtherRequisitionClass clsdbo_OtherRequisition = new dbo_OtherRequisitionClass();
SqlConnection connection = SAMDataClass.GetConnection();
string selectProcedure = "[OtherRequisitionSelect]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@Requisition_No", Requisition_No);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_OtherRequisition.Requisition_No = reader["Requisition_No"] is DBNull ? null : reader["Requisition_No"].ToString();
clsdbo_OtherRequisition.CV_Code = reader["CV_Code"] is DBNull ? null : reader["CV_Code"].ToString();
clsdbo_OtherRequisition.Requisition_Date = reader["Requisition_Date"] is DBNull ? null : (DateTime?)reader["Requisition_Date"];
clsdbo_OtherRequisition.Requisition_Name = reader["Requisition_Name"] is DBNull ? null : reader["Requisition_Name"].ToString();
clsdbo_OtherRequisition.Other_Requisition_Name = reader["Other_Requisition_Name"] is DBNull ? null : reader["Other_Requisition_Name"].ToString();
clsdbo_OtherRequisition.Reason = reader["Reason"] is DBNull ? null : reader["Reason"].ToString();
clsdbo_OtherRequisition.Other_reason = reader["Other_reason"] is DBNull ? null : reader["Other_reason"].ToString();
clsdbo_OtherRequisition.Grand_Total_Qty = reader["Grand_Total_Qty"] is DBNull ? null : (Int32?)reader["Grand_Total_Qty"];
clsdbo_OtherRequisition.Grand_Total_Amount = reader["Grand_Total_Amount"] is DBNull ? null : (Decimal?)reader["Grand_Total_Amount"];
}
else
{
clsdbo_OtherRequisition = null;
}
reader.Close();
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(clsdbo_OtherRequisition);
}
finally
{
connection.Close();
}
return(clsdbo_OtherRequisition);
}
public static bool Delete(dbo_OtherRequisitionClass clsdbo_OtherRequisition)
{
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 deleteProcedure = "[dbo].[OtherRequisitionDelete]";
SqlCommand deleteCommand = new SqlCommand(deleteProcedure, connection);
deleteCommand.CommandType = CommandType.StoredProcedure;
if (clsdbo_OtherRequisition.Requisition_No != null)
{
deleteCommand.Parameters.AddWithValue("@OldRequisition_No", clsdbo_OtherRequisition.Requisition_No);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldRequisition_No", DBNull.Value);
}
if (clsdbo_OtherRequisition.CV_Code != null)
{
deleteCommand.Parameters.AddWithValue("@OldCV_Code", clsdbo_OtherRequisition.CV_Code);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldCV_Code", DBNull.Value);
}
if (clsdbo_OtherRequisition.Requisition_Date.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldRequisition_Date", clsdbo_OtherRequisition.Requisition_Date);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldRequisition_Date", DBNull.Value);
}
if (clsdbo_OtherRequisition.Requisition_Name != null)
{
deleteCommand.Parameters.AddWithValue("@OldRequisition_Name", clsdbo_OtherRequisition.Requisition_Name);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldRequisition_Name", DBNull.Value);
}
if (clsdbo_OtherRequisition.Other_Requisition_Name != null)
{
deleteCommand.Parameters.AddWithValue("@OldOther_Requisition_Name", clsdbo_OtherRequisition.Other_Requisition_Name);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldOther_Requisition_Name", DBNull.Value);
}
if (clsdbo_OtherRequisition.Reason != null)
{
deleteCommand.Parameters.AddWithValue("@OldReason", clsdbo_OtherRequisition.Reason);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldReason", DBNull.Value);
}
if (clsdbo_OtherRequisition.Grand_Total_Qty.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldGrand_Total_Qty", clsdbo_OtherRequisition.Grand_Total_Qty);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldGrand_Total_Qty", DBNull.Value);
}
if (clsdbo_OtherRequisition.Grand_Total_Amount.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldGrand_Total_Amount", clsdbo_OtherRequisition.Grand_Total_Amount);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldGrand_Total_Amount", DBNull.Value);
}
deleteCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int);
deleteCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
try
{
connection.Open();
deleteCommand.ExecuteNonQuery();
int count = System.Convert.ToInt32(deleteCommand.Parameters["@ReturnValue"].Value);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(false);
}
finally
{
connection.Close();
}
}
