public int InsertDM_MODULE(DM_MODULE dm_module)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
DbParameter ouput = _DbHelper.CreateParameter(FIELD_IDMODULE, DbType.Int32, true);
para.Add(_DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, dm_module.IDMA_DVIQLY, false));
para.Add(_DbHelper.CreateParameter(FIELD_CONNECTSTRING, dm_module.ConnectString, false));
para.Add(_DbHelper.CreateParameter(FIELD_NAME, dm_module.Name, false));
para.Add(_DbHelper.CreateParameter(FIELD_CODE, dm_module.Code, false));
para.Add(_DbHelper.CreateParameter(FIELD_IDUSER, dm_module.IDUSER, false));
para.Add(ouput);
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_MODULE_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("DM_MODULEDataAccess.Insert: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
protected void grvPartitionManager_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
string strCn = e.NewValues["ConnectString"] + "";
string code = e.NewValues["Code"] + "";
int IDUser = 0, id_DV = 0;
if (e.NewValues[4] != null)
{
IDUser = int.Parse(e.NewValues[4] + "");
}
if (e.NewValues[2] != null)
{
id_DV = int.Parse(e.NewValues[2] + "");
}
TestConnect(strCn, code);
var sysPartitionService = new DM_MODULEService();
SYS_ConfigConnectionServer configConnectionServer = new SYS_ConfigConnectionServer();
var partition = new DM_MODULE
{
Name = e.NewValues["Name"] + "",
Code = code,
IDUSER = IDUser,
IDMA_DVIQLY = id_DV,
ConnectString = configConnectionServer.EncryptSYS_ConfigConnection(strCn)
};
sysPartitionService.InsertDM_MODULE(partition);
_DataBind();
e.Cancel = true;
grvModunManager.CancelEdit();
//WriteLog("Insert " + e.NewValues["Name"] + "", Action.Create);
}
public DM_MODULE SelectDM_MODULE(int IDMODULE)
{
DM_MODULE dm_module = new DM_MODULE();
DbDataReader reader = null;
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_IDMODULE, IDMODULE, false));
reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[DM_MODULE_SelectById]", para.ToArray());
if (reader.HasRows && reader.Read())
{
DM_MODULEDataAccess.SetDM_MODULEInfo(reader, ref dm_module);
}
return(dm_module);
}
catch (Exception ex)
{
throw new Exception(String.Format("DM_MODULEDataAccess.SelectById: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
conn.Close();
}
}
public void UpdateDM_MODULE(DM_MODULE dm_module)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_IDMODULE, dm_module.IDMODULE, false));
para.Add(_DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, dm_module.IDMA_DVIQLY, false));
para.Add(_DbHelper.CreateParameter(FIELD_CONNECTSTRING, dm_module.ConnectString, false));
para.Add(_DbHelper.CreateParameter(FIELD_NAME, dm_module.Name, false));
para.Add(_DbHelper.CreateParameter(FIELD_CODE, dm_module.Code, false));
para.Add(_DbHelper.CreateParameter(FIELD_IDUSER, dm_module.IDUSER, false));
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_MODULE_Update]", para.ToArray());
}
catch (Exception ex)
{
throw new Exception(String.Format("DM_MODULEDataAccess.Update: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
protected void grvPartitionManager_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
string strCn = e.NewValues["ConnectString"] + "";
string code = e.NewValues["Code"] + "";
DM_MODULE sysModun = (DM_MODULE)grvModunManager.GetRow(grvModunManager.EditingRowVisibleIndex);
int IDUser = sysModun.IDUSER;
int idDV = sysModun.IDMA_DVIQLY;
int testInt = 0;
if (e.NewValues["USERNAME"] != null)
{
if (int.TryParse(e.NewValues["USERNAME"] + "", out testInt))
{
IDUser = int.Parse(e.NewValues["USERNAME"] + "");
}
else
{
IDUser = returnIDUser(e.NewValues["USERNAME"] + "");
}
}
if (e.NewValues["NAME_DVIQLY"] != null)
{
if (int.TryParse(e.NewValues["NAME_DVIQLY"] + "", out testInt))
{
idDV = int.Parse(e.NewValues["NAME_DVIQLY"] + "");
}
else
{
idDV = returnIDMaDV(e.NewValues["NAME_DVIQLY"] + "");
}
}
if (e.OldValues["Code"].ToString() != e.NewValues["Code"].ToString())
{
TestConnect(strCn, code);
}
SYS_ConfigConnectionServer configConnectionServer = new SYS_ConfigConnectionServer();
var sysPartitionService = new DM_MODULEService();
var partition = new DM_MODULE
{
IDMODULE = (int)e.Keys["IDMODULE"],
Name = e.NewValues["Name"] + "",
Code = code,
IDUSER = IDUser,
IDMA_DVIQLY = idDV,
ConnectString = configConnectionServer.EncryptSYS_ConfigConnection(strCn)
};
sysPartitionService.UpdateDM_MODULE(partition);
_DataBind();
e.Cancel = true;
grvModunManager.CancelEdit();
//WriteLog("Update " + e.NewValues["Name"] + "", Action.Update);
}
private static void SetBindingListDM_MODULEInfo(ref DbDataReader reader, ref BindingList <DM_MODULE> dm_modules)
{
DM_MODULE dm_module = null;
while (reader.Read())
{
dm_module = new DM_MODULE();
DM_MODULEDataAccess.SetDM_MODULEInfo(reader, ref dm_module);
dm_modules.Add(dm_module);
}
}
private static void SetDM_MODULEInfo(DbDataReader reader, ref DM_MODULE dm_module)
{
dm_module.IDMODULE = int.Parse("0" + reader[FIELD_IDMODULE]);
dm_module.Code = "" + reader[FIELD_CODE];
dm_module.Name = "" + reader[FIELD_NAME];
dm_module.ConnectString = "" + reader[FIELD_CONNECTSTRING];
dm_module.IDUSER = int.Parse("0" + reader[FIELD_IDUSER]);
dm_module.USERNAME = "" + reader[FIELD_USERNAME];
dm_module.NAME_DVIQLY = "" + reader[FIELD_NAME_DVIQLY];
dm_module.IDMA_DVIQLY = int.Parse("" + reader[FIELD_IDMA_DVIQLY]);
}
protected void grvPartitionManager_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
var sysModunService = new DM_MODULEService();
var Modun = new DM_MODULE {
IDMODULE = (int)e.Keys["IDMODULE"]
};
sysModunService.DeleteDM_MODULE(Modun);
_DataBind();
e.Cancel = true;
//WriteLog("Delete " + Modun.Name, Action.Delete);
}
public void DeleteDM_MODULE(DM_MODULE dm_module)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_IDMODULE, dm_module.IDMODULE, false));
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_MODULE_Delete]", para.ToArray());
}
catch (Exception ex)
{
throw new Exception(String.Format("DM_MODULEDataAccess.SelectById: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
public void DeleteDM_MODULE(DM_MODULE dm_modules)
{
_dm_moduleDataAccess.DeleteDM_MODULE(dm_modules);
}
public void UpdateDM_MODULE(DM_MODULE dm_module)
{
_dm_moduleDataAccess.UpdateDM_MODULE(dm_module);
}
public int InsertDM_MODULE(DM_MODULE dm_module)
{
return(_dm_moduleDataAccess.InsertDM_MODULE(dm_module));
}