public static dbo_RequisitionDetailClass Select_Record(dbo_RequisitionDetailClass clsdbo_RequisitionDetailPara)
{
dbo_RequisitionDetailClass clsdbo_RequisitionDetail = new dbo_RequisitionDetailClass();
SqlConnection connection = SAMDataClass.GetConnection();
string selectProcedure = "[dbo].[RequisitionDetailSelect]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@Requisition_Detail_ID", clsdbo_RequisitionDetailPara.Requisition_Detail_ID);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_RequisitionDetail.Requisition_Detail_ID = reader["Requisition_Detail_ID"] is DBNull ? null : reader["Requisition_Detail_ID"].ToString();
clsdbo_RequisitionDetail.Requisition_No = reader["Requisition_No"] is DBNull ? null : reader["Requisition_No"].ToString();
clsdbo_RequisitionDetail.Time_No = reader["Time_No"] is DBNull ? null : reader["Time_No"].ToString();
clsdbo_RequisitionDetail.Product_ID = reader["Product_ID"] is DBNull ? null : reader["Product_ID"].ToString();
clsdbo_RequisitionDetail.Price = reader["Price"] is DBNull ? null : (Decimal?)reader["Price"];
clsdbo_RequisitionDetail.Vat = reader["Vat"] is DBNull ? null : (Byte?)reader["Vat"];
clsdbo_RequisitionDetail.Previous_Balance_Qty = reader["Previous_Balance_Qty"] is DBNull ? null : (Int16?)reader["Previous_Balance_Qty"];
clsdbo_RequisitionDetail.Suggestion_Qty = reader["Suggestion_Qty"] is DBNull ? null : (Int16?)reader["Suggestion_Qty"];
clsdbo_RequisitionDetail.Sub_Total_Qty = reader["Sub_Total_Qty"] is DBNull ? null : (Int16?)reader["Sub_Total_Qty"];
clsdbo_RequisitionDetail.Requisition_Qty = reader["Requisition_Qty"] is DBNull ? null : (Int16?)reader["Requisition_Qty"];
clsdbo_RequisitionDetail.Total_Qty = reader["Total_Qty"] is DBNull ? null : (Int16?)reader["Total_Qty"];
clsdbo_RequisitionDetail.Selling_Price = reader["Selling_Price"] is DBNull ? null : (Decimal?)reader["Selling_Price"];
clsdbo_RequisitionDetail.Total_Price = reader["Total_Price"] is DBNull ? null : (Decimal?)reader["Total_Price"];
clsdbo_RequisitionDetail.Commission = reader["Commission"] is DBNull ? null : (Decimal?)reader["Commission"];
clsdbo_RequisitionDetail.Point = reader["Point"] is DBNull ? null : (Byte?)reader["Point"];
clsdbo_RequisitionDetail.Deposit_Qty = reader["Deposit_Qty"] is DBNull ? null : (Byte?)reader["Deposit_Qty"];
}
else
{
clsdbo_RequisitionDetail = null;
}
reader.Close();
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(clsdbo_RequisitionDetail);
}
finally
{
connection.Close();
}
return(clsdbo_RequisitionDetail);
}
public static bool Delete(dbo_RequisitionDetailClass clsdbo_RequisitionDetail)
{
SqlConnection connection = SAMDataClass.GetConnection();
string deleteProcedure = "[dbo].[RequisitionDetailDelete]";
SqlCommand deleteCommand = new SqlCommand(deleteProcedure, connection);
deleteCommand.CommandType = CommandType.StoredProcedure;
if (clsdbo_RequisitionDetail.Requisition_Detail_ID != null)
{
deleteCommand.Parameters.AddWithValue("@OldRequisition_Detail_ID", clsdbo_RequisitionDetail.Requisition_Detail_ID);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldRequisition_Detail_ID", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Requisition_No != null)
{
deleteCommand.Parameters.AddWithValue("@OldRequisition_No", clsdbo_RequisitionDetail.Requisition_No);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldRequisition_No", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Time_No != null)
{
deleteCommand.Parameters.AddWithValue("@OldTime_No", clsdbo_RequisitionDetail.Time_No);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldTime_No", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Product_ID != null)
{
deleteCommand.Parameters.AddWithValue("@OldProduct_ID", clsdbo_RequisitionDetail.Product_ID);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldProduct_ID", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Price.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldPrice", clsdbo_RequisitionDetail.Price);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldPrice", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Vat.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldVat", clsdbo_RequisitionDetail.Vat);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldVat", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Previous_Balance_Qty.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldPrevious_Balance_Qty", clsdbo_RequisitionDetail.Previous_Balance_Qty);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldPrevious_Balance_Qty", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Suggestion_Qty.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldSuggestion_Qty", clsdbo_RequisitionDetail.Suggestion_Qty);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldSuggestion_Qty", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Sub_Total_Qty.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldSub_Total_Qty", clsdbo_RequisitionDetail.Sub_Total_Qty);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldSub_Total_Qty", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Requisition_Qty.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldRequisition_Qty", clsdbo_RequisitionDetail.Requisition_Qty);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldRequisition_Qty", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Total_Qty.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldTotal_Qty", clsdbo_RequisitionDetail.Total_Qty);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldTotal_Qty", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Selling_Price.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldSelling_Price", clsdbo_RequisitionDetail.Selling_Price);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldSelling_Price", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Total_Price.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldTotal_Price", clsdbo_RequisitionDetail.Total_Price);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldTotal_Price", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Commission.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldCommission", clsdbo_RequisitionDetail.Commission);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldCommission", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Point.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldPoint", clsdbo_RequisitionDetail.Point);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldPoint", 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();
}
}
public static bool Update(dbo_RequisitionDetailClass newdbo_RequisitionDetailClass)
{
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 updateProcedure = "[RequisitionDetailUpdate]";
SqlCommand updateCommand = new SqlCommand(updateProcedure, connection);
updateCommand.CommandType = CommandType.StoredProcedure;
if (newdbo_RequisitionDetailClass.Requisition_Detail_ID != null)
{
updateCommand.Parameters.AddWithValue("@NewRequisition_Detail_ID", newdbo_RequisitionDetailClass.Requisition_Detail_ID);
}
else
{
updateCommand.Parameters.AddWithValue("@NewRequisition_Detail_ID", DBNull.Value);
}
if (newdbo_RequisitionDetailClass.Requisition_No != null)
{
updateCommand.Parameters.AddWithValue("@NewRequisition_No", newdbo_RequisitionDetailClass.Requisition_No);
}
else
{
updateCommand.Parameters.AddWithValue("@NewRequisition_No", DBNull.Value);
}
if (newdbo_RequisitionDetailClass.Time_No != null)
{
updateCommand.Parameters.AddWithValue("@NewTime_No", newdbo_RequisitionDetailClass.Time_No);
}
else
{
updateCommand.Parameters.AddWithValue("@NewTime_No", DBNull.Value);
}
if (newdbo_RequisitionDetailClass.Product_ID != null)
{
updateCommand.Parameters.AddWithValue("@NewProduct_ID", newdbo_RequisitionDetailClass.Product_ID);
}
else
{
updateCommand.Parameters.AddWithValue("@NewProduct_ID", DBNull.Value);
}
if (newdbo_RequisitionDetailClass.Price.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewPrice", newdbo_RequisitionDetailClass.Price);
}
else
{
updateCommand.Parameters.AddWithValue("@NewPrice", DBNull.Value);
}
if (newdbo_RequisitionDetailClass.Vat.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewVat", newdbo_RequisitionDetailClass.Vat);
}
else
{
updateCommand.Parameters.AddWithValue("@NewVat", DBNull.Value);
}
if (newdbo_RequisitionDetailClass.Previous_Balance_Qty.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewPrevious_Balance_Qty", newdbo_RequisitionDetailClass.Previous_Balance_Qty);
}
else
{
updateCommand.Parameters.AddWithValue("@NewPrevious_Balance_Qty", DBNull.Value);
}
if (newdbo_RequisitionDetailClass.Suggestion_Qty.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewSuggestion_Qty", newdbo_RequisitionDetailClass.Suggestion_Qty);
}
else
{
updateCommand.Parameters.AddWithValue("@NewSuggestion_Qty", DBNull.Value);
}
if (newdbo_RequisitionDetailClass.Sub_Total_Qty.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewSub_Total_Qty", newdbo_RequisitionDetailClass.Sub_Total_Qty);
}
else
{
updateCommand.Parameters.AddWithValue("@NewSub_Total_Qty", DBNull.Value);
}
if (newdbo_RequisitionDetailClass.Requisition_Qty.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewRequisition_Qty", newdbo_RequisitionDetailClass.Requisition_Qty);
}
else
{
updateCommand.Parameters.AddWithValue("@NewRequisition_Qty", DBNull.Value);
}
if (newdbo_RequisitionDetailClass.Total_Qty.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewTotal_Qty", newdbo_RequisitionDetailClass.Total_Qty);
}
else
{
updateCommand.Parameters.AddWithValue("@NewTotal_Qty", DBNull.Value);
}
if (newdbo_RequisitionDetailClass.Selling_Price.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewSelling_Price", newdbo_RequisitionDetailClass.Selling_Price);
}
else
{
updateCommand.Parameters.AddWithValue("@NewSelling_Price", DBNull.Value);
}
if (newdbo_RequisitionDetailClass.Total_Price.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewTotal_Price", newdbo_RequisitionDetailClass.Total_Price);
}
else
{
updateCommand.Parameters.AddWithValue("@NewTotal_Price", DBNull.Value);
}
if (newdbo_RequisitionDetailClass.Commission.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewCommission", newdbo_RequisitionDetailClass.Commission);
}
else
{
updateCommand.Parameters.AddWithValue("@NewCommission", DBNull.Value);
}
if (newdbo_RequisitionDetailClass.Point.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewPoint", newdbo_RequisitionDetailClass.Point);
}
else
{
updateCommand.Parameters.AddWithValue("@NewPoint", DBNull.Value);
}
if (newdbo_RequisitionDetailClass.Deposit_Qty.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewDeposit_Qty", newdbo_RequisitionDetailClass.Deposit_Qty);
}
else
{
updateCommand.Parameters.AddWithValue("@NewDeposit_Qty", DBNull.Value);
}
if (newdbo_RequisitionDetailClass.Return_Qty.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewReturn_Qty", newdbo_RequisitionDetailClass.Return_Qty);
}
else
{
updateCommand.Parameters.AddWithValue("@NewReturn_Qty", 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_RequisitionDetailClass clsdbo_RequisitionDetail, String Created_By)
{
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 = "RequisitionDetailInsert";
SqlCommand insertCommand = new SqlCommand(insertProcedure, connection);
insertCommand.CommandType = CommandType.StoredProcedure;
if (clsdbo_RequisitionDetail.Requisition_Detail_ID != null)
{
insertCommand.Parameters.AddWithValue("@Requisition_Detail_ID", clsdbo_RequisitionDetail.Requisition_Detail_ID);
}
else
{
insertCommand.Parameters.AddWithValue("@Requisition_Detail_ID", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Requisition_No != null)
{
insertCommand.Parameters.AddWithValue("@Requisition_No", clsdbo_RequisitionDetail.Requisition_No);
}
else
{
insertCommand.Parameters.AddWithValue("@Requisition_No", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Time_No != null)
{
insertCommand.Parameters.AddWithValue("@Time_No", clsdbo_RequisitionDetail.Time_No);
}
else
{
insertCommand.Parameters.AddWithValue("@Time_No", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Product_ID != null)
{
insertCommand.Parameters.AddWithValue("@Product_ID", clsdbo_RequisitionDetail.Product_ID);
}
else
{
insertCommand.Parameters.AddWithValue("@Product_ID", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Price.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Price", clsdbo_RequisitionDetail.Price);
}
else
{
insertCommand.Parameters.AddWithValue("@Price", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Vat.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Vat", clsdbo_RequisitionDetail.Vat);
}
else
{
insertCommand.Parameters.AddWithValue("@Vat", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Previous_Balance_Qty.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Previous_Balance_Qty", clsdbo_RequisitionDetail.Previous_Balance_Qty);
}
else
{
insertCommand.Parameters.AddWithValue("@Previous_Balance_Qty", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Suggestion_Qty.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Suggestion_Qty", clsdbo_RequisitionDetail.Suggestion_Qty);
}
else
{
insertCommand.Parameters.AddWithValue("@Suggestion_Qty", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Sub_Total_Qty.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Sub_Total_Qty", clsdbo_RequisitionDetail.Sub_Total_Qty);
}
else
{
insertCommand.Parameters.AddWithValue("@Sub_Total_Qty", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Requisition_Qty.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Requisition_Qty", clsdbo_RequisitionDetail.Requisition_Qty);
}
else
{
insertCommand.Parameters.AddWithValue("@Requisition_Qty", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Total_Qty.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Total_Qty", clsdbo_RequisitionDetail.Total_Qty);
}
else
{
insertCommand.Parameters.AddWithValue("@Total_Qty", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Selling_Price.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Selling_Price", clsdbo_RequisitionDetail.Selling_Price);
}
else
{
insertCommand.Parameters.AddWithValue("@Selling_Price", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Total_Price.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Total_Price", clsdbo_RequisitionDetail.Total_Price);
}
else
{
insertCommand.Parameters.AddWithValue("@Total_Price", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Commission.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Commission", clsdbo_RequisitionDetail.Commission);
}
else
{
insertCommand.Parameters.AddWithValue("@Commission", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Point.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Point", clsdbo_RequisitionDetail.Point);
}
else
{
insertCommand.Parameters.AddWithValue("@Point", DBNull.Value);
}
if (clsdbo_RequisitionDetail.Deposit_Qty.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Deposit_Qty", clsdbo_RequisitionDetail.Deposit_Qty);
}
else
{
insertCommand.Parameters.AddWithValue("@Deposit_Qty", DBNull.Value);
}
if (!string.IsNullOrEmpty(Created_By))
{
insertCommand.Parameters.AddWithValue("@Created_By", Created_By);
}
else
{
insertCommand.Parameters.AddWithValue("@Created_By", 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();
}
}
