private void InsertRecord()
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
dbo_ProductClass clsdbo_Product = new dbo_ProductClass();
SetData(clsdbo_Product);
bool success = false;
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
success = dbo_ProductDataClass.Add(clsdbo_Product, User_ID);
dbo_ProductListClass clsdbo_ProductList = new dbo_ProductListClass();
List <dbo_PriceGroupClass> price_group = dbo_PriceGroupDataClass.Search(string.Empty, "0");
dbo_PriceGroupClass price_group_id = price_group.FirstOrDefault(f => f.StandardPrice == true);
clsdbo_ProductList.Price_Group_ID = price_group_id.Price_Group_ID;
clsdbo_ProductList.Product_List_ID = GenerateID.Product_List_ID();
var date = new DateTime(9456, 12, 31);
clsdbo_ProductList.Agent_Price = clsdbo_Product.Agent_Price;
clsdbo_ProductList.Product_Effective_Date = DateTime.Now;
clsdbo_ProductList.Start_Effective_Date = DateTime.Now;
clsdbo_ProductList.End_Effective_Date = date;
clsdbo_ProductList.Product_ID = clsdbo_Product.Product_ID;
clsdbo_ProductList.Product_Name = clsdbo_Product.Product_Name;
clsdbo_ProductList.Point = clsdbo_Product.Point;
clsdbo_ProductList.Vat = clsdbo_Product.Vat;
//clsdbo_ProductList.CP_Meiji_Price = clsdbo_Product.CP_Meiji_Price;
dbo_ProductListDataClass.Add(clsdbo_ProductList, User_ID);
price_group = dbo_PriceGroupDataClass.Search(string.Empty, "1");
price_group_id = price_group.FirstOrDefault(f => f.StandardPrice == true);
if (price_group_id != null)
{
clsdbo_ProductList.Price_Group_ID = price_group_id.Price_Group_ID;
clsdbo_ProductList.SP_Price = clsdbo_Product.SP_Price;
clsdbo_ProductList.CP_Meiji_Price = clsdbo_Product.CP_Meiji_Price;
clsdbo_ProductList.Agent_Price = null;
clsdbo_ProductList.Product_List_ID = GenerateID.Product_List_ID();
dbo_ProductListDataClass.Add(clsdbo_ProductList, User_ID);
}
if (success)
{
Show("บันทึกสำเร็จ");
}
else
{
Show("error");
}
}
public static dbo_PriceGroupClass Select_Record(string Price_Group_ID)
{
dbo_PriceGroupClass clsdbo_PriceGroup = new dbo_PriceGroupClass();
SqlConnection connection = SAMDataClass.GetConnection();
string selectProcedure = "PriceGroupSelect";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@Price_Group_ID", Price_Group_ID);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_PriceGroup.Price_Group_ID = reader["Price_Group_ID"] is DBNull ? null : reader["Price_Group_ID"].ToString();
clsdbo_PriceGroup.Price_Group_Name = reader["Price_Group_Name"] is DBNull ? null : reader["Price_Group_Name"].ToString();
clsdbo_PriceGroup.Price_Group_Type = reader["Price_Group_Type"] is DBNull ? null : (reader["Price_Group_Type"].ToString() == "0" ? "เอเยนต์" : "สาว");
clsdbo_PriceGroup.StandardPrice = reader["StandardPrice"] is DBNull ? false : (Boolean)reader["StandardPrice"];
}
else
{
clsdbo_PriceGroup = null;
}
reader.Close();
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(clsdbo_PriceGroup);
}
finally
{
connection.Close();
}
return(clsdbo_PriceGroup);
}
public static bool Update(dbo_PriceGroupClass newdbo_PriceGroupClass, String Last_Modified_By)
{
SqlConnection connection = SAMDataClass.GetConnection();
string updateProcedure = "PriceGroupUpdate";
SqlCommand updateCommand = new SqlCommand(updateProcedure, connection);
updateCommand.CommandType = CommandType.StoredProcedure;
if (newdbo_PriceGroupClass.Price_Group_ID != null)
{
updateCommand.Parameters.AddWithValue("@NewPrice_Group_ID", newdbo_PriceGroupClass.Price_Group_ID);
}
else
{
updateCommand.Parameters.AddWithValue("@NewPrice_Group_ID", DBNull.Value);
}
if (newdbo_PriceGroupClass.Price_Group_Name != null)
{
updateCommand.Parameters.AddWithValue("@NewPrice_Group_Name", newdbo_PriceGroupClass.Price_Group_Name);
}
else
{
updateCommand.Parameters.AddWithValue("@NewPrice_Group_Name", DBNull.Value);
}
if (newdbo_PriceGroupClass.StandardPrice != null)
{
updateCommand.Parameters.AddWithValue("@StandardPrice", newdbo_PriceGroupClass.StandardPrice);
}
else
{
updateCommand.Parameters.AddWithValue("@StandardPrice", DBNull.Value);
}
if (Last_Modified_By != null)
{
updateCommand.Parameters.AddWithValue("@Last_Modified_By", Last_Modified_By);
}
else
{
updateCommand.Parameters.AddWithValue("@Last_Modified_By", 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_PriceGroupClass clsdbo_PriceGroup, String Created_By)
{
SqlConnection connection = SAMDataClass.GetConnection();
string insertProcedure = "[PriceGroupInsert]";
SqlCommand insertCommand = new SqlCommand(insertProcedure, connection);
insertCommand.CommandType = CommandType.StoredProcedure;
if (clsdbo_PriceGroup.Price_Group_ID != null)
{
insertCommand.Parameters.AddWithValue("@Price_Group_ID", clsdbo_PriceGroup.Price_Group_ID);
}
else
{
insertCommand.Parameters.AddWithValue("@Price_Group_ID", DBNull.Value);
}
if (clsdbo_PriceGroup.Price_Group_Name != null)
{
insertCommand.Parameters.AddWithValue("@Price_Group_Name", clsdbo_PriceGroup.Price_Group_Name);
}
else
{
insertCommand.Parameters.AddWithValue("@Price_Group_Name", DBNull.Value);
}
if (clsdbo_PriceGroup.Price_Group_Type != null)
{
insertCommand.Parameters.AddWithValue("@Price_Group_Type", clsdbo_PriceGroup.Price_Group_Type);
}
else
{
insertCommand.Parameters.AddWithValue("@Price_Group_Type", DBNull.Value);
}
if (clsdbo_PriceGroup.StandardPrice != null)
{
insertCommand.Parameters.AddWithValue("@StandardPrice", clsdbo_PriceGroup.StandardPrice);
}
else
{
insertCommand.Parameters.AddWithValue("@StandardPrice", DBNull.Value);
}
if (Created_By != null)
{
insertCommand.Parameters.AddWithValue("@Created_By", Created_By);
}
else
{
insertCommand.Parameters.AddWithValue("@Created_By", DBNull.Value);
}
if (Created_By != null)
{
insertCommand.Parameters.AddWithValue("@CV_Code", Created_By);
}
else
{
insertCommand.Parameters.AddWithValue("@CV_Code", 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();
}
}
