/*public static DataTable Search(string sField, string sCondition, string sValue)
* {
* SqlConnection connection = SAMDataClass.GetConnection();
* string selectProcedure = "[dbo].[OtherRequisitionDetailSearch]";
* SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
* selectCommand.CommandType = CommandType.StoredProcedure;
* if (sField == "Other Requisition Detail I D")
* {
* selectCommand.Parameters.AddWithValue("@Other_Requisition_Detail_ID", sValue);
* }
* else
* {
* selectCommand.Parameters.AddWithValue("@Other_Requisition_Detail_ID", DBNull.Value);
* }
* if (sField == "Requisition No")
* {
* selectCommand.Parameters.AddWithValue("@Requisition_No", sValue);
* }
* else
* {
* selectCommand.Parameters.AddWithValue("@Requisition_No", DBNull.Value);
* }
* if (sField == "Product I D")
* {
* selectCommand.Parameters.AddWithValue("@Product_ID", sValue);
* }
* else
* {
* selectCommand.Parameters.AddWithValue("@Product_ID", DBNull.Value);
* }
* if (sField == "Price")
* {
* selectCommand.Parameters.AddWithValue("@Price", sValue);
* }
* else
* {
* selectCommand.Parameters.AddWithValue("@Price", DBNull.Value);
* }
* if (sField == "Vat")
* {
* selectCommand.Parameters.AddWithValue("@Vat", sValue);
* }
* else
* {
* selectCommand.Parameters.AddWithValue("@Vat", DBNull.Value);
* }
* if (sField == "Stock On Hand")
* {
* selectCommand.Parameters.AddWithValue("@Stock_on_Hand", sValue);
* }
* else
* {
* selectCommand.Parameters.AddWithValue("@Stock_on_Hand", DBNull.Value);
* }
* if (sField == "Requisition Qty")
* {
* selectCommand.Parameters.AddWithValue("@Requisition_Qty", sValue);
* }
* else
* {
* selectCommand.Parameters.AddWithValue("@Requisition_Qty", DBNull.Value);
* }
* selectCommand.Parameters.AddWithValue("@SearchCondition", sCondition);
* DataTable dt = new DataTable();
* try
* {
* connection.Open();
* SqlDataReader reader = selectCommand.ExecuteReader();
* if (reader.HasRows)
* {
* dt.Load(reader);
* }
* reader.Close();
* }
* catch (SqlException ex)
* {
* logger.Error(ex.Message);
* return dt;
* }
* finally
* {
* connection.Close();
* }
* return dt;
* }*/
public static dbo_OtherRequisitionDetailClass Select_Record(dbo_OtherRequisitionDetailClass clsdbo_OtherRequisitionDetailPara)
{
dbo_OtherRequisitionDetailClass clsdbo_OtherRequisitionDetail = new dbo_OtherRequisitionDetailClass();
SqlConnection connection = SAMDataClass.GetConnection();
string selectProcedure = "[dbo].[OtherRequisitionDetailSelect]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@Other_Requisition_Detail_ID", clsdbo_OtherRequisitionDetailPara.Other_Requisition_Detail_ID);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_OtherRequisitionDetail.Other_Requisition_Detail_ID = reader["Other_Requisition_Detail_ID"] is DBNull ? null : reader["Other_Requisition_Detail_ID"].ToString();
clsdbo_OtherRequisitionDetail.Requisition_No = reader["Requisition_No"] is DBNull ? null : reader["Requisition_No"].ToString();
clsdbo_OtherRequisitionDetail.Product_ID = reader["Product_ID"] is DBNull ? null : reader["Product_ID"].ToString();
clsdbo_OtherRequisitionDetail.Price = reader["Price"] is DBNull ? null : (Decimal?)reader["Price"];
clsdbo_OtherRequisitionDetail.Vat = reader["Vat"] is DBNull ? null : (Byte?)reader["Vat"];
clsdbo_OtherRequisitionDetail.Stock_on_Hand = reader["Stock_on_Hand"] is DBNull ? null : (Int32?)reader["Stock_on_Hand"];
clsdbo_OtherRequisitionDetail.Requisition_Qty = reader["Requisition_Qty"] is DBNull ? null : (Int16?)reader["Requisition_Qty"];
}
else
{
clsdbo_OtherRequisitionDetail = null;
}
reader.Close();
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(clsdbo_OtherRequisitionDetail);
}
finally
{
connection.Close();
}
return(clsdbo_OtherRequisitionDetail);
}
public static bool Delete(dbo_OtherRequisitionDetailClass clsdbo_OtherRequisitionDetail)
{
SqlConnection connection = SAMDataClass.GetConnection();
string deleteProcedure = "[dbo].[OtherRequisitionDetailDelete]";
SqlCommand deleteCommand = new SqlCommand(deleteProcedure, connection);
deleteCommand.CommandType = CommandType.StoredProcedure;
if (clsdbo_OtherRequisitionDetail.Other_Requisition_Detail_ID != null)
{
deleteCommand.Parameters.AddWithValue("@OldOther_Requisition_Detail_ID", clsdbo_OtherRequisitionDetail.Other_Requisition_Detail_ID);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldOther_Requisition_Detail_ID", DBNull.Value);
}
if (clsdbo_OtherRequisitionDetail.Requisition_No != null)
{
deleteCommand.Parameters.AddWithValue("@OldRequisition_No", clsdbo_OtherRequisitionDetail.Requisition_No);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldRequisition_No", DBNull.Value);
}
/*if (clsdbo_OtherRequisitionDetail.Product_ID != null)
* {
* deleteCommand.Parameters.AddWithValue("@OldProduct_ID", clsdbo_OtherRequisitionDetail.Product_ID);
* }
* else
* {
* deleteCommand.Parameters.AddWithValue("@OldProduct_ID", DBNull.Value);
* }
* if (clsdbo_OtherRequisitionDetail.Price.HasValue == true)
* {
* deleteCommand.Parameters.AddWithValue("@OldPrice", clsdbo_OtherRequisitionDetail.Price);
* }
* else
* {
* deleteCommand.Parameters.AddWithValue("@OldPrice", DBNull.Value);
* }
* if (clsdbo_OtherRequisitionDetail.Vat.HasValue == true)
* {
* deleteCommand.Parameters.AddWithValue("@OldVat", clsdbo_OtherRequisitionDetail.Vat);
* }
* else
* {
* deleteCommand.Parameters.AddWithValue("@OldVat", DBNull.Value);
* }
* if (clsdbo_OtherRequisitionDetail.Stock_on_Hand.HasValue == true)
* {
* deleteCommand.Parameters.AddWithValue("@OldStock_on_Hand", clsdbo_OtherRequisitionDetail.Stock_on_Hand);
* }
* else
* {
* deleteCommand.Parameters.AddWithValue("@OldStock_on_Hand", DBNull.Value);
* }
* if (clsdbo_OtherRequisitionDetail.Requisition_Qty.HasValue == true)
* {
* deleteCommand.Parameters.AddWithValue("@OldRequisition_Qty", clsdbo_OtherRequisitionDetail.Requisition_Qty);
* }
* else
* {
* deleteCommand.Parameters.AddWithValue("@OldRequisition_Qty", 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_OtherRequisitionDetailClass newdbo_OtherRequisitionDetailClass)
{
SqlConnection connection = SAMDataClass.GetConnection();
string updateProcedure = "[OtherRequisitionDetailUpdate]";
SqlCommand updateCommand = new SqlCommand(updateProcedure, connection);
updateCommand.CommandType = CommandType.StoredProcedure;
if (newdbo_OtherRequisitionDetailClass.Other_Requisition_Detail_ID != null)
{
updateCommand.Parameters.AddWithValue("@NewOther_Requisition_Detail_ID", newdbo_OtherRequisitionDetailClass.Other_Requisition_Detail_ID);
}
else
{
updateCommand.Parameters.AddWithValue("@NewOther_Requisition_Detail_ID", DBNull.Value);
}
if (newdbo_OtherRequisitionDetailClass.Requisition_No != null)
{
updateCommand.Parameters.AddWithValue("@NewRequisition_No", newdbo_OtherRequisitionDetailClass.Requisition_No);
}
else
{
updateCommand.Parameters.AddWithValue("@NewRequisition_No", DBNull.Value);
}
if (newdbo_OtherRequisitionDetailClass.Product_ID != null)
{
updateCommand.Parameters.AddWithValue("@NewProduct_ID", newdbo_OtherRequisitionDetailClass.Product_ID);
}
else
{
updateCommand.Parameters.AddWithValue("@NewProduct_ID", DBNull.Value);
}
if (newdbo_OtherRequisitionDetailClass.Price.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewPrice", newdbo_OtherRequisitionDetailClass.Price);
}
else
{
updateCommand.Parameters.AddWithValue("@NewPrice", DBNull.Value);
}
if (newdbo_OtherRequisitionDetailClass.Vat.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewVat", newdbo_OtherRequisitionDetailClass.Vat);
}
else
{
updateCommand.Parameters.AddWithValue("@NewVat", DBNull.Value);
}
if (newdbo_OtherRequisitionDetailClass.Stock_on_Hand.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewStock_on_Hand", newdbo_OtherRequisitionDetailClass.Stock_on_Hand);
}
else
{
updateCommand.Parameters.AddWithValue("@NewStock_on_Hand", DBNull.Value);
}
if (newdbo_OtherRequisitionDetailClass.Requisition_Qty.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewRequisition_Qty", newdbo_OtherRequisitionDetailClass.Requisition_Qty);
}
else
{
updateCommand.Parameters.AddWithValue("@NewRequisition_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_OtherRequisitionDetailClass clsdbo_OtherRequisitionDetail, String Created_By)
{
SqlConnection connection = SAMDataClass.GetConnection();
string insertProcedure = "[dbo].[OtherRequisitionDetailInsert]";
SqlCommand insertCommand = new SqlCommand(insertProcedure, connection);
insertCommand.CommandType = CommandType.StoredProcedure;
if (clsdbo_OtherRequisitionDetail.Other_Requisition_Detail_ID != null)
{
insertCommand.Parameters.AddWithValue("@Other_Requisition_Detail_ID", clsdbo_OtherRequisitionDetail.Other_Requisition_Detail_ID);
}
else
{
insertCommand.Parameters.AddWithValue("@Other_Requisition_Detail_ID", DBNull.Value);
}
if (clsdbo_OtherRequisitionDetail.Requisition_No != null)
{
insertCommand.Parameters.AddWithValue("@Requisition_No", clsdbo_OtherRequisitionDetail.Requisition_No);
}
else
{
insertCommand.Parameters.AddWithValue("@Requisition_No", DBNull.Value);
}
if (clsdbo_OtherRequisitionDetail.Product_ID != null)
{
insertCommand.Parameters.AddWithValue("@Product_ID", clsdbo_OtherRequisitionDetail.Product_ID);
}
else
{
insertCommand.Parameters.AddWithValue("@Product_ID", DBNull.Value);
}
if (clsdbo_OtherRequisitionDetail.Price.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Price", clsdbo_OtherRequisitionDetail.Price);
}
else
{
insertCommand.Parameters.AddWithValue("@Price", DBNull.Value);
}
if (clsdbo_OtherRequisitionDetail.Vat.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Vat", clsdbo_OtherRequisitionDetail.Vat);
}
else
{
insertCommand.Parameters.AddWithValue("@Vat", DBNull.Value);
}
if (clsdbo_OtherRequisitionDetail.Stock_on_Hand.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Stock_on_Hand", clsdbo_OtherRequisitionDetail.Stock_on_Hand);
}
else
{
insertCommand.Parameters.AddWithValue("@Stock_on_Hand", DBNull.Value);
}
if (clsdbo_OtherRequisitionDetail.Requisition_Qty.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Requisition_Qty", clsdbo_OtherRequisitionDetail.Requisition_Qty);
}
else
{
insertCommand.Parameters.AddWithValue("@Requisition_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();
}
}