public static dbo_DepositDetailClass Select_Record(dbo_DepositDetailClass clsdbo_DepositDetailPara)
{
dbo_DepositDetailClass clsdbo_DepositDetail = new dbo_DepositDetailClass();
SqlConnection connection = SAMDataClass.GetConnection();
string selectProcedure = "[dbo].[DepositDetailSelect]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@Deposit_Detail_ID", clsdbo_DepositDetailPara.Deposit_Detail_ID);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_DepositDetail.Deposit_Detail_ID = reader["Deposit_Detail_ID"] is DBNull ? null : reader["Deposit_Detail_ID"].ToString();
clsdbo_DepositDetail.Clearing_No = reader["Clearing_No"] is DBNull ? null : reader["Clearing_No"].ToString();
clsdbo_DepositDetail.Product_ID = reader["Product_ID"] is DBNull ? null : reader["Product_ID"].ToString();
clsdbo_DepositDetail.Price = reader["Price"] is DBNull ? null : (Decimal?)reader["Price"];
clsdbo_DepositDetail.Total_Qty = reader["Total_Qty"] is DBNull ? null : (Int16?)reader["Total_Qty"];
clsdbo_DepositDetail.Deposit_Qty = reader["Deposit_Qty"] is DBNull ? null : (Int16?)reader["Deposit_Qty"];
clsdbo_DepositDetail.Deposit_Return_flag = reader["Deposit_Return_flag"] is DBNull ? null : (Boolean?)reader["Deposit_Return_flag"];
clsdbo_DepositDetail.Selling_Price = reader["Selling_Price"] is DBNull ? null : (Decimal?)reader["Selling_Price"];
clsdbo_DepositDetail.Sales_Qty = reader["Sales_Qty"] is DBNull ? null : (Int16?)reader["Sales_Qty"];
clsdbo_DepositDetail.Sales_Amount = reader["Sales_Amount"] is DBNull ? null : (Decimal?)reader["Sales_Amount"];
clsdbo_DepositDetail.Commission = reader["Commission"] is DBNull ? null : (Decimal?)reader["Commission"];
clsdbo_DepositDetail.Point = reader["Point"] is DBNull ? null : (Byte?)reader["Point"];
clsdbo_DepositDetail.Product_List_ID = reader["Product_List_ID"] is DBNull ? null : reader["Product_List_ID"].ToString();
clsdbo_DepositDetail.Return_Qty = reader["Return_Qty"] is DBNull ? null : (Int16?)reader["Return_Qty"];
}
else
{
clsdbo_DepositDetail = null;
}
reader.Close();
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(clsdbo_DepositDetail);
}
finally
{
connection.Close();
}
return(clsdbo_DepositDetail);
}
public static bool Update(dbo_DepositDetailClass newdbo_DepositDetailClass)
{
SqlConnection connection = SAMDataClass.GetConnection();
string updateProcedure = "[DepositDetailUpdate]";
SqlCommand updateCommand = new SqlCommand(updateProcedure, connection);
updateCommand.CommandType = CommandType.StoredProcedure;
if (newdbo_DepositDetailClass.Deposit_Detail_ID != null)
{
updateCommand.Parameters.AddWithValue("@NewDeposit_Detail_ID", newdbo_DepositDetailClass.Deposit_Detail_ID);
}
else
{
updateCommand.Parameters.AddWithValue("@NewDeposit_Detail_ID", DBNull.Value);
}
if (newdbo_DepositDetailClass.Clearing_No != null)
{
updateCommand.Parameters.AddWithValue("@NewClearing_No", newdbo_DepositDetailClass.Clearing_No);
}
else
{
updateCommand.Parameters.AddWithValue("@NewClearing_No", DBNull.Value);
}
if (newdbo_DepositDetailClass.Product_ID != null)
{
updateCommand.Parameters.AddWithValue("@NewProduct_ID", newdbo_DepositDetailClass.Product_ID);
}
else
{
updateCommand.Parameters.AddWithValue("@NewProduct_ID", DBNull.Value);
}
if (newdbo_DepositDetailClass.Price.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewPrice", newdbo_DepositDetailClass.Price);
}
else
{
updateCommand.Parameters.AddWithValue("@NewPrice", DBNull.Value);
}
if (newdbo_DepositDetailClass.Total_Qty.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewTotal_Qty", newdbo_DepositDetailClass.Total_Qty);
}
else
{
updateCommand.Parameters.AddWithValue("@NewTotal_Qty", DBNull.Value);
}
if (newdbo_DepositDetailClass.Deposit_Qty.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewDeposit_Qty", newdbo_DepositDetailClass.Deposit_Qty);
}
else
{
updateCommand.Parameters.AddWithValue("@NewDeposit_Qty", DBNull.Value);
}
if (newdbo_DepositDetailClass.Deposit_Return_flag.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewDeposit_Return_flag", newdbo_DepositDetailClass.Deposit_Return_flag);
}
else
{
updateCommand.Parameters.AddWithValue("@NewDeposit_Return_flag", DBNull.Value);
}
if (newdbo_DepositDetailClass.Selling_Price.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewSelling_Price", newdbo_DepositDetailClass.Selling_Price);
}
else
{
updateCommand.Parameters.AddWithValue("@NewSelling_Price", DBNull.Value);
}
if (newdbo_DepositDetailClass.Sales_Qty.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewSales_Qty", newdbo_DepositDetailClass.Sales_Qty);
}
else
{
updateCommand.Parameters.AddWithValue("@NewSales_Qty", DBNull.Value);
}
if (newdbo_DepositDetailClass.Sales_Amount.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewSales_Amount", newdbo_DepositDetailClass.Sales_Amount);
}
else
{
updateCommand.Parameters.AddWithValue("@NewSales_Amount", DBNull.Value);
}
if (newdbo_DepositDetailClass.Commission.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewCommission", newdbo_DepositDetailClass.Commission);
}
else
{
updateCommand.Parameters.AddWithValue("@NewCommission", DBNull.Value);
}
if (newdbo_DepositDetailClass.Point.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewPoint", newdbo_DepositDetailClass.Point);
}
else
{
updateCommand.Parameters.AddWithValue("@NewPoint", DBNull.Value);
}
if (newdbo_DepositDetailClass.Product_List_ID != null)
{
updateCommand.Parameters.AddWithValue("@NewProduct_List_ID", newdbo_DepositDetailClass.Product_List_ID);
}
else
{
updateCommand.Parameters.AddWithValue("@NewProduct_List_ID", DBNull.Value);
}
if (newdbo_DepositDetailClass.Return_Qty.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewReturn_Qty", newdbo_DepositDetailClass.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_DepositDetailClass clsdbo_DepositDetail)
{
SqlConnection connection = SAMDataClass.GetConnection();
string insertProcedure = "[dbo].[DepositDetailInsert]";
SqlCommand insertCommand = new SqlCommand(insertProcedure, connection);
insertCommand.CommandType = CommandType.StoredProcedure;
if (clsdbo_DepositDetail.Deposit_Detail_ID != null)
{
insertCommand.Parameters.AddWithValue("@Deposit_Detail_ID", clsdbo_DepositDetail.Deposit_Detail_ID);
}
else
{
insertCommand.Parameters.AddWithValue("@Deposit_Detail_ID", DBNull.Value);
}
if (clsdbo_DepositDetail.Clearing_No != null)
{
insertCommand.Parameters.AddWithValue("@Clearing_No", clsdbo_DepositDetail.Clearing_No);
}
else
{
insertCommand.Parameters.AddWithValue("@Clearing_No", DBNull.Value);
}
if (clsdbo_DepositDetail.Product_ID != null)
{
insertCommand.Parameters.AddWithValue("@Product_ID", clsdbo_DepositDetail.Product_ID);
}
else
{
insertCommand.Parameters.AddWithValue("@Product_ID", DBNull.Value);
}
if (clsdbo_DepositDetail.Price.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Price", clsdbo_DepositDetail.Price);
}
else
{
insertCommand.Parameters.AddWithValue("@Price", DBNull.Value);
}
if (clsdbo_DepositDetail.Total_Qty.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Total_Qty", clsdbo_DepositDetail.Total_Qty);
}
else
{
insertCommand.Parameters.AddWithValue("@Total_Qty", DBNull.Value);
}
if (clsdbo_DepositDetail.Deposit_Qty.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Deposit_Qty", clsdbo_DepositDetail.Deposit_Qty);
}
else
{
insertCommand.Parameters.AddWithValue("@Deposit_Qty", DBNull.Value);
}
if (clsdbo_DepositDetail.Deposit_Return_flag.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Deposit_Return_flag", clsdbo_DepositDetail.Deposit_Return_flag);
}
else
{
insertCommand.Parameters.AddWithValue("@Deposit_Return_flag", DBNull.Value);
}
if (clsdbo_DepositDetail.Selling_Price.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Selling_Price", clsdbo_DepositDetail.Selling_Price);
}
else
{
insertCommand.Parameters.AddWithValue("@Selling_Price", DBNull.Value);
}
if (clsdbo_DepositDetail.Sales_Qty.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Sales_Qty", clsdbo_DepositDetail.Sales_Qty);
}
else
{
insertCommand.Parameters.AddWithValue("@Sales_Qty", DBNull.Value);
}
if (clsdbo_DepositDetail.Sales_Amount.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Sales_Amount", clsdbo_DepositDetail.Sales_Amount);
}
else
{
insertCommand.Parameters.AddWithValue("@Sales_Amount", DBNull.Value);
}
if (clsdbo_DepositDetail.Commission.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Commission", clsdbo_DepositDetail.Commission);
}
else
{
insertCommand.Parameters.AddWithValue("@Commission", DBNull.Value);
}
if (clsdbo_DepositDetail.Point.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Point", clsdbo_DepositDetail.Point);
}
else
{
insertCommand.Parameters.AddWithValue("@Point", DBNull.Value);
}
if (clsdbo_DepositDetail.Product_List_ID != null)
{
insertCommand.Parameters.AddWithValue("@Product_List_ID", clsdbo_DepositDetail.Product_List_ID);
}
else
{
insertCommand.Parameters.AddWithValue("@Product_List_ID", DBNull.Value);
}
if (clsdbo_DepositDetail.Return_Qty.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Return_Qty", clsdbo_DepositDetail.Return_Qty);
}
else
{
insertCommand.Parameters.AddWithValue("@Return_Qty", 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();
}
}
