public static int Insert(ConfigItem p_configItem, DataRow p_row)
{
int ma = 0;
try
{
object[] arrValue = new object[] {
p_row["Name"],
p_row["Group_Pk"],
p_configItem.Login_UserName,
p_row["Remark"],
p_row["Unit_Pk"],
p_row["slton"]
};
string[] arrParaName = new string[] {
"@Name",
"@Group_Pk",
"@Crt_By",
"@Remark",
"@Unit_Pk",
"@number_in"
};
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
ma = _sql.ExecuteInsert("USP_INS_ITEM", arrNames: arrParaName, arrValues: arrValue);
}
catch (Exception ex)
{
throw ex;
}
return(ma);
}
public static int Insert(ConfigItem p_ConfigItem, object[] parramValue)
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
string[] arrParaName = new string[] {
"@Name",
"@Phone",
"@Address",
"@Fax",
"@Email",
"@Website",
"@Crt_By",
"@TaxCode",
"@Credit",
"@Debit"
};
_sql.Connect(p_ConfigItem);
return(_sql.ExecuteInsert("USP_INS_SUPPLIER", arrParaName, parramValue));
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
}
private bool InsertData(DataTable tbDetail, int _id_WareHouse, int _TotalAMT, int _iId_Supplier_Pk, DateTime _iTake_In_Date, int _User_Pk, string _BillNumber, string _Remark, DateTime _billdate)
{
System.Data.SqlClient.SqlConnection _sqlConnection = new System.Data.SqlClient.SqlConnection(_ConfigItem.StrConnection);
if (_sqlConnection.State != ConnectionState.Open)
{
_sqlConnection.Open();
}
System.Data.SqlClient.SqlTransaction _sqlTransaction = _sqlConnection.BeginTransaction();
try
{
int _iNumberItem = tbDetail.Rows.Count;
string[] arrName = new string[] { "@Supplier_Pk", "@Take_In_Date", "@Number_Item", "@TotalAMT", "@Crt_By", "@WareHouse_Pk", "@Remark", "@BillNumber", "@BillDate", "@User_Pk" };
object[] arrValue = new object[] { _iId_Supplier_Pk, _iTake_In_Date, _iNumberItem, _TotalAMT, _ConfigItem.Login_UserName, _id_WareHouse, _Remark, _BillNumber, _billdate, _User_Pk };
_providerSQL = new COREBASE.COMMAND.SQL.AccessSQL();
int _idMaster = _providerSQL.ExecuteInsert(_sqlConnection, _sqlTransaction, "USP_INS_TAKE_IN", arrName, arrValue);
for (int i = 0; i < _iNumberItem; i++)
{
arrName = new string[] {
"@Take_In_Pk",
"@Crt_By",
"@Remark",
"@Number_Bill",
"@Number_Real",
"@Price",
"@Vat",
"@Item_Pk",
"@UnitStyle_Pk"
};
arrValue = new object[] {
_idMaster,
_ConfigItem.Login_UserName,
string.Empty,
tbDetail.Rows[i]["Number_Bill"],
tbDetail.Rows[i]["Number_Real"],
tbDetail.Rows[i]["Price"],
tbDetail.Rows[i]["Vat"],
tbDetail.Rows[i]["Item_Pk"],
tbDetail.Rows[i]["UnitStyle_Pk"]
};
_providerSQL.ExecuteNonQuery(_sqlConnection, _sqlTransaction, "USP_INS_TAKE_IN_DETAIL", arrName, arrValue);
}
_sqlTransaction.Commit();
_providerSQL.Disconnect(_sqlConnection);
return(true);
}
catch (Exception ex)
{
_sqlTransaction.Rollback();
AppDebug(ex);
if (_providerSQL != null)
{
if (_sqlConnection != null)
{
_providerSQL.Disconnect(_sqlConnection);
}
}
return(false);
}
}
public static int Insert(ConfigItem p_configItem, DataRow p_dtRow)
{
int ma = 0;
try
{
object[] arrValue = new object[] {
p_dtRow["Unit_In_Pk"],
p_dtRow["Unit_Out_Pk"],
p_dtRow["Remark"],
p_dtRow["Num"],
p_configItem.Login_UserName
};
string[] arrParaName = new string[] {
"@Unit_In_Pk",
"@Unit_Out_Pk",
"@Remark",
"@Num",
"@Crt_By"
};
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
ma = _sql.ExecuteInsert("USP_INS_UNIT_STYLE", arrParaName, arrValue);
}
catch (Exception ex)
{
throw ex;
}
return(ma);
}
public static int Insert(ConfigItem p_ConfigItem, object[] arrValue)
{
int ma = 0;
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
string[] arrParaName = new string[] {
"@Name_Dis",
"@Name",
"@Password",
"@Crt_By",
"@Remark",
"@Phone",
"@Address",
"@Department_Pk"
};
_sql.Connect(p_ConfigItem);
ma = _sql.ExecuteInsert("USP_INS_USER", arrNames: arrParaName, arrValues: arrValue);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
return(ma);
}
public static int Insert(ConfigItem p_ConfigItem, Supplier p_Supplier)
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
string[] arrParaName = new string[] {
"@Name",
"@Phone",
"@Phone1",
"@Address",
"@Address1",
"@Fax",
"@Email",
"@Website",
"@Crt_By",
"@TaxCode",
"@Credit",
"@Debit"
};
object[] arrParaValue = new object[] {
p_Supplier.Name,
p_Supplier.Phone,
p_Supplier.Phone1,
p_Supplier.Address,
p_Supplier.Address1,
p_Supplier.Fax,
p_Supplier.Email,
p_Supplier.Website,
p_ConfigItem.Login_UserName,
p_Supplier.TaxCode,
p_Supplier.Credit,
p_Supplier.Debit
};
_sql.Connect(p_ConfigItem);
return(_sql.ExecuteInsert("USP_INS_SUPPLIER", arrParaName, arrParaValue));
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
}
public int Insert(object[] arrValue)
{
int ma = 0;
try
{
string[] arrParaName = new string[] {
"@Item_Pk",
"@Department_Form_Pk",
"@Department_To_Pk",
"@Number_Item"
};
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(confItem);
ma = _sql.ExecuteInsert("USP_INS_TRANFERITEM", arrNames: arrParaName, arrValues: arrValue);
}
catch (Exception ex)
{
throw ex;
}
return(ma);
}
public static int Insert(ConfigItem p_ConfigItem, object[] arrValue)
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
string[] arrParaName = new string[] {
"@Name",
"@Crt_Dt",
"@Crt_By",
"@Remark"
};
_sql.Connect(p_ConfigItem);
return(_sql.ExecuteInsert("USP_INS_UNIT", arrNames: arrParaName, arrValues: arrValue));
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
}
public int Insert(object [] arrValue)
{
int ma = 0;
try
{
string[] arrParaName = new string[] {
"@Name",
"@Crt_Dt",
"@Crt_By",
"@Is_Del",
"@Remark",
"@Id_Cat"
};
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(confItem);
ma = _sql.ExecuteInsert("usp_InsertVPP_GROUP", arrNames: arrParaName, arrValues: arrValue);
}
catch (Exception ex)
{
throw ex;
}
return(ma);
}
public int Insert(object[] arrValue)
{
int ma = 0;
try
{
string[] arrParaName = new string[] {
"@Id_Dis",
"@Name",
"@Crt_By",
"@Remark",
"@Phone",
"@LeaderId"
};
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(confItem);
ma = _sql.ExecuteInsert("USP_INS_DEPARTMENT", arrNames: arrParaName, arrValues: arrValue);
}
catch (Exception ex)
{
throw ex;
}
return(ma);
}
public static int Insert(ConfigItem p_configItem, DataRow p_drGroup)
{
COREBASE.COMMAND.SQL.AccessSQL l_sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
try
{
string[] l_arrName = new string[] { "@Name", "@Crt_By", "@Remark", "@ID_Cat" };
object[] l_arrValue = new object[] {
p_drGroup["Name"],
p_configItem.Login_UserName,
p_drGroup["Remark"],
p_drGroup["Id_Cat"]
};
l_sql.Connect(p_configItem);
return(l_sql.ExecuteInsert("USP_INS_GROUP", l_arrName, l_arrValue));
}
catch (Exception ex)
{
throw ex;
}
finally
{
l_sql.Disconnect();
}
}
public static bool Insert(ConfigItem p_ConfigItem, DataRow p_drValue, DataTable p_dtValue)
{
bool l_rs = false;
System.Data.SqlClient.SqlConnection _sqlConnection = new System.Data.SqlClient.SqlConnection(p_ConfigItem.StrConnection);
if (_sqlConnection.State != ConnectionState.Open)
{
_sqlConnection.Open();
}
System.Data.SqlClient.SqlTransaction _sqlTransaction = _sqlConnection.BeginTransaction();
COREBASE.COMMAND.SQL.AccessSQL _providerSQL = new COREBASE.COMMAND.SQL.AccessSQL();
try
{
string[] arrParaName = new string[] {
"@Number_Item",
"@Remark",
"@Crt_By",
"@Department_pk",
"@PriceTotal",
"@Take_Out_Date",
"@User_Pk"
};
object[] arrValue = new object[] {
p_drValue["Number_Item"],
p_drValue["Remark"],
p_ConfigItem.Login_ID,
p_drValue["Department_pk"],
p_drValue["PriceTotal"],
p_drValue["Take_Out_Date"],
p_drValue["User_Pk"]
};
int _idMaster = _providerSQL.ExecuteInsert(_sqlConnection, _sqlTransaction, "USP_INS_TAKE_OUT", arrParaName, arrValue);
arrParaName = new string[] {
"@Take_Out_Pk",
"@Crt_By",
"@Remark",
"@Take_Out_Number",
"@Price",
"@Item_Pk",
"@UnitStyle_Pk"
};
for (int i = 0; i < p_dtValue.Rows.Count; i++)
{
DataRow l_drValue = p_dtValue.Rows[i];
arrValue = new object[] {
_idMaster,
p_ConfigItem.Login_ID,
l_drValue["Remark"],
l_drValue["Number_Real"],
l_drValue["Price"],
l_drValue["Item_Pk"],
l_drValue["UnitStyle_Pk"]
};
_providerSQL.ExecuteNonQuery(_sqlConnection, _sqlTransaction, "USP_INS_TAKE_OUT_DETAIL", arrParaName, arrValue);
}
_sqlTransaction.Commit();
l_rs = true;
}
catch (Exception ex)
{
_sqlTransaction.Rollback();
throw ex;
}
finally
{
_providerSQL.Disconnect(_sqlConnection);
}
return(l_rs);
}