public string SAVE_MAKHACHHANG_TO_ORACLE()
{
string RESULT = "";
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString))
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
try
{
int CURRENT = 0;
OracleCommand command = new OracleCommand();
command.Connection = connection;
string querySelectItem = "SELECT \"TYPE\",CODE,\"CURRENT\" FROM MD_ID_BUILDER WHERE CODE = 'KH'";
command.CommandText = querySelectItem;
command.CommandType = CommandType.Text;
OracleDataReader dataReaderBuildCode = command.ExecuteReader();
if (dataReaderBuildCode.HasRows)
{
while (dataReaderBuildCode.Read())
{
MD_ID_BUILDER _MD_ID_BUILDER = new MD_ID_BUILDER();
_MD_ID_BUILDER.ID = Guid.NewGuid().ToString();
_MD_ID_BUILDER.TYPE = "KH";
_MD_ID_BUILDER.CODE = "KH";
_MD_ID_BUILDER.CURRENT = "0000";
_MD_ID_BUILDER.UNITCODE = Session.Session.CurrentUnitCode;
int CURRENT_NUMBER = 0;
int.TryParse(dataReaderBuildCode["CURRENT"].ToString(), out CURRENT_NUMBER);
string SO_MA = GENERATE_NUMBER(CURRENT_NUMBER.ToString());
_MD_ID_BUILDER.CURRENT = SO_MA;
OracleCommand commandUpdate = new OracleCommand();
commandUpdate.Connection = connection;
string queryUpdateItem = "UPDATE MD_ID_BUILDER SET \"CURRENT\" = '" + _MD_ID_BUILDER.CURRENT + "' WHERE \"TYPE\" = '" + _MD_ID_BUILDER.TYPE + "' AND \"CODE\" = '" + _MD_ID_BUILDER.CODE + "' ";
commandUpdate.CommandText = queryUpdateItem;
commandUpdate.CommandType = CommandType.Text;
commandUpdate.ExecuteNonQuery();
RESULT = string.Format("{0}{1}", _MD_ID_BUILDER.CODE, SO_MA);
}
}
else
{
MD_ID_BUILDER _MD_ID_BUILDER = new MD_ID_BUILDER();
_MD_ID_BUILDER.ID = Guid.NewGuid().ToString();
_MD_ID_BUILDER.TYPE = "KH";
_MD_ID_BUILDER.CODE = "KH";
_MD_ID_BUILDER.CURRENT = "0000";
_MD_ID_BUILDER.UNITCODE = Session.Session.CurrentUnitCode;
string SO_MA = GENERATE_NUMBER(_MD_ID_BUILDER.CURRENT);
_MD_ID_BUILDER.CURRENT = SO_MA;
OracleCommand commandInsert = new OracleCommand();
commandInsert.Connection = connection;
string queryInsertItem = "INSERT INTO MD_ID_BUILDER(ID,\"TYPE\",CODE,\"CURRENT\",\"UNITCODE\",NGAYTAO) VALUES ('" + _MD_ID_BUILDER.ID + "','" + _MD_ID_BUILDER.TYPE + "','" + _MD_ID_BUILDER.TYPE + "','" + _MD_ID_BUILDER.CURRENT + "','" + _MD_ID_BUILDER.UNITCODE + "','" + DateTime.Now + "')";
commandInsert.CommandText = queryInsertItem;
commandInsert.CommandType = CommandType.Text;
commandInsert.ExecuteNonQuery();
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
finally
{
connection.Close();
connection.Dispose();
}
}
else
{
NotificationLauncher.ShowNotificationError("THÔNG BÁO", "KHÔNG CÓ KẾT NỐI VỚI CƠ SỞ DỮ LIỆU ORACLE", 1, "0x1", "0x8", "normal");
}
}
return(RESULT);
}
public string SAVE_MAKHACHHANG_TO_ORACLE()
{
string RESULT = "";
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString))
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
try
{
OracleCommand command = new OracleCommand();
command.Connection = connection;
string querySelectItem = "SELECT LOAIMA,NHOMMA,GIATRI,UNITCODE FROM CAPMA WHERE LOAIMA='VIP' AND NHOMMA = 'KHACHHANG'";
command.CommandText = querySelectItem;
command.CommandType = CommandType.Text;
OracleDataReader dataReaderBuildCode = command.ExecuteReader();
if (dataReaderBuildCode.HasRows)
{
while (dataReaderBuildCode.Read())
{
MD_ID_BUILDER _MD_ID_BUILDER = new MD_ID_BUILDER();
_MD_ID_BUILDER.ID = Guid.NewGuid().ToString();
_MD_ID_BUILDER.LOAIMA = "VIP";
_MD_ID_BUILDER.NHOMMA = "KHACHHANG";
_MD_ID_BUILDER.GIATRI = "0";
_MD_ID_BUILDER.UNITCODE = Session.Session.CurrentUnitCode;
int CURRENT_NUMBER = 0;
int.TryParse(dataReaderBuildCode["GIATRI"].ToString(), out CURRENT_NUMBER);
string SO_MA = GENERATE_NUMBER(CURRENT_NUMBER.ToString());
_MD_ID_BUILDER.GIATRI = SO_MA;
OracleCommand commandUpdate = new OracleCommand();
commandUpdate.Connection = connection;
string queryUpdateItem = "UPDATE CAPMA SET GIATRI = '" + _MD_ID_BUILDER.GIATRI + "' WHERE LOAIMA = '" + _MD_ID_BUILDER.LOAIMA + "' AND NHOMMA = '" + _MD_ID_BUILDER.NHOMMA + "' ";
commandUpdate.CommandText = queryUpdateItem;
commandUpdate.CommandType = CommandType.Text;
commandUpdate.ExecuteNonQuery();
RESULT = string.Format("{0}{1}", _MD_ID_BUILDER.LOAIMA, SO_MA);
}
}
else
{
MD_ID_BUILDER _MD_ID_BUILDER = new MD_ID_BUILDER();
_MD_ID_BUILDER.ID = Guid.NewGuid().ToString();
_MD_ID_BUILDER.LOAIMA = "VIP";
_MD_ID_BUILDER.NHOMMA = "KHACHHANG";
_MD_ID_BUILDER.GIATRI = "0";
_MD_ID_BUILDER.UNITCODE = Session.Session.CurrentUnitCode;
string SO_MA = GENERATE_NUMBER(_MD_ID_BUILDER.GIATRI);
_MD_ID_BUILDER.GIATRI = SO_MA;
OracleCommand commandInsert = new OracleCommand();
commandInsert.Connection = connection;
string queryInsertItem = "INSERT INTO CAPMA(ID,LOAIMA,NHOMMA,GIATRI,\"UNITCODE\") VALUES ('" + _MD_ID_BUILDER.ID + "','" + _MD_ID_BUILDER.LOAIMA + "','" + _MD_ID_BUILDER.NHOMMA + "','" + _MD_ID_BUILDER.GIATRI + "','" + _MD_ID_BUILDER.UNITCODE + "')";
commandInsert.CommandText = queryInsertItem;
commandInsert.CommandType = CommandType.Text;
commandInsert.ExecuteNonQuery();
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
finally
{
connection.Close();
connection.Dispose();
}
}
else
{
NotificationLauncher.ShowNotificationError("THÔNG BÁO", "KHÔNG CÓ KẾT NỐI VỚI CƠ SỞ DỮ LIỆU ORACLE", 1, "0x1", "0x8", "normal");
}
}
return(RESULT);
}
