protected void gridEmail_InsertCommand(object sender, GridRecordEventArgs e)
{
oboutGrid_utils o = new oboutGrid_utils();
o.oGrid_InsertData(e.Record, "tblEmail", "backend", "dbo", "householdID", GetHouseholdID());
//RefreshGrid(gridEmail, "hh.spEmail_by_HouseholdID", Request.QueryString["hhID"]);
}
protected void Grid1_Select(object sender, GridRecordEventArgs e)
{
Hashtable selectedRecord = e.RecordsCollection[0] as Hashtable;
SqlDataSource2.SelectParameters[0].DefaultValue = selectedRecord["OrderID"].ToString();
SuperForm1.DataBind();
}
protected void UpdateRecord(object sender, GridRecordEventArgs e)
{
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/Northwind.mdb"));
myConn.Open();
OleDbCommand myComm = new OleDbCommand("UPDATE Orders SET ShipName = @ShipName, ShipAddress=@ShipAddress, ShipCity = @ShipCity, ShipRegion=@ShipRegion, ShipPostalCode=@ShipPostalCode, ShipCountry = @ShipCountry, Sent = @Sent, OrderDate=@OrderDate, RequiredDate=@RequiredDate, ShippedDate=@ShippedDate, ShipVia=@ShipVia, AdditionalInformation=@AdditionalInformation WHERE OrderID = @OrderID", myConn);
myComm.Parameters.Add("@ShipName", OleDbType.VarChar).Value = e.Record["ShipName"];
myComm.Parameters.Add("@ShipAddress", OleDbType.VarChar).Value = e.Record["ShipAddress"];
myComm.Parameters.Add("@ShipCity", OleDbType.VarChar).Value = e.Record["ShipCity"];
myComm.Parameters.Add("@ShipRegion", OleDbType.VarChar).Value = e.Record["ShipRegion"];
myComm.Parameters.Add("@ShipPostalCode", OleDbType.VarChar).Value = e.Record["ShipPostalCode"];
myComm.Parameters.Add("@ShipCountry", OleDbType.VarChar).Value = e.Record["ShipCountry"];
myComm.Parameters.Add("@Sent", OleDbType.Boolean).Value = e.Record["Sent"];
myComm.Parameters.Add("@OrderDate", OleDbType.Date).Value = e.Record["OrderDateFormatted"];
myComm.Parameters.Add("@RequiredDate", OleDbType.Date).Value = e.Record["RequiredDateFormatted"];
myComm.Parameters.Add("@ShippedDate", OleDbType.Date).Value = e.Record["ShippedDateFormatted"];
myComm.Parameters.Add("@ShipVia", OleDbType.Integer).Value = e.Record["ShipVia"];
myComm.Parameters.Add("@AdditionalInformation", OleDbType.VarChar).Value = e.Record["AdditionalInformation"];
myComm.Parameters.Add("@OrderID", OleDbType.Integer).Value = e.Record["OrderID"];
myComm.ExecuteNonQuery();
myConn.Close();
}
protected void ogrid_detail_UpdateCommand(object sender, GridRecordEventArgs e)
{
if (detail_tbl != "")
{
Hashtable hash = e.Record;
string detail_pkval = hash["detail_pk"].ToString();
hash.Add(detail_pk, detail_pkval);
// Add studyID whether we need it or not. Because the oGrid_InsertData will only
// process fields that are part of the underlying table, no harm in including it.
if (hash.ContainsKey("studyID"))
{
hash["studyID"] = Master.Master_studyID.ToString();
}
else
{
hash.Add("studyID", Master.Master_studyID.ToString());
}
oboutGrid_utils o = new oboutGrid_utils();
string output = o.oGrid_UpdateData(hash, detail_tbl, "uwautism_research_backend", schema, detail_pk);
lblOutput_detail.Text = output;
LoadDetail(schema, master_tbl, master_pk, detail_tbl, detail_pk, master_pkvalue, usestudy);
}
}
void InsertRecord(object sender, GridRecordEventArgs e)
{
/*
* OctAccSprVal = Convert.ToInt32(e.Record["OCTACCSPRVAL"]);
* OctSum = Convert.ToDecimal(e.Record["OCTSUM"]);
*
* // строка соединение
* string connectionString = WebConfigurationManager.ConnectionStrings[MdbNam].ConnectionString;
* // создание соединение Connection
* SqlConnection con = new SqlConnection(connectionString);
* con.Open();
*
* // создание команды
* SqlCommand cmd = new SqlCommand("BuxOctAnlAdd", con);
* cmd = new SqlCommand("BuxOctAnlAdd", con);
* // указать тип команды
* cmd.CommandType = CommandType.StoredProcedure;
* // создать коллекцию параметров
* cmd.Parameters.Add("@BUXSID", SqlDbType.VarChar).Value = BuxSid;
* cmd.Parameters.Add("@BUXFRM", SqlDbType.Int, 4).Value = BuxFrm;
* cmd.Parameters.Add("@OCTACC", SqlDbType.Int, 4).Value = OctAcc;
* cmd.Parameters.Add("@OCTACCSPR", SqlDbType.Int, 4).Value = OctAccSpr;
* cmd.Parameters.Add("@OCTACCSPRVAL", SqlDbType.Int, 4).Value = OctAccSprVal;
* cmd.Parameters.Add("@OCTSUM", SqlDbType.Decimal).Value = OctSum;
* cmd.Parameters.Add("@OCTGOD", SqlDbType.Int, 4).Value = OctGod;
* // ------------------------------------------------------------------------------заполняем первый уровень
* // создание команды
* cmd.ExecuteNonQuery();
* con.Close();
* // ------------------------------------------------------------------------------заполняем второй уровень
* // localhost.Service1Soap ws = new localhost.Service1SoapClient();
* // ws.ComSprBuxAdd(MdbNam, BuxSid, BuxFrm, OctKod, BuxDlg, BuxLog, BuxPsw);
* LoadGridNode();
*/
}
// ======================================================================================
void InsertRecord(object sender, GridRecordEventArgs e)
{
string RabDat;
RabDat = Convert.ToString(e.Record["AMBDAT"]);
if (string.IsNullOrEmpty(RabDat))
{
AmbDat = DateTime.Now;
}
else
{
AmbDat = DateTime.Parse(RabDat);
}
RabDat = Convert.ToString(e.Record["AMBBEG"]);
if (string.IsNullOrEmpty(RabDat))
{
AmbBeg = DateTime.Now.ToString("dd.MM.yyyy HH:mm:ss");
}
else
{
AmbBeg = RabDat;
}
AmbDat = Convert.ToDateTime(e.Record["AMBDAT"]);
AmbPth = Convert.ToString(e.Record["AMBPTH"]);
AmbTel = Convert.ToString(e.Record["AMBTEL"]);
AmbUsl = Convert.ToInt32(e.Record["AMBUSL"]);
AmbZen = Convert.ToInt32(e.Record["AMBZEN"]);
AmbKod = Convert.ToInt32(e.Record["AMBKOD"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.AmbCrdTabAdd(MdbNam, BuxSid, BuxFrm, AmbKod, AmbDat, AmbBeg, AmbPth, AmbTel, AmbUsl, AmbZen);
getGrid();
}
protected void Grid1_Select(object sender, GridRecordEventArgs e)
{
Hashtable selectedRecord = e.RecordsCollection[0] as Hashtable;
SqlDataSource2.SelectParameters[0].DefaultValue = selectedRecord["OrderID"].ToString();
SuperForm1.DefaultMode = DetailsViewMode.Edit;
SuperForm1.DataBind();
}
public void UpdateCustomer(object sender, GridRecordEventArgs e)
{
// try to update the customer
// ...
// throw an exception if something goes wrong
throw new Exception("An error occured when trying to update the customer.");
}
public void InsertOrder(object sender, GridRecordEventArgs e)
{
// try to insert the order
// ...
// throw an exception if something goes wrong
throw new Exception("An error occured when trying to insert the order.");
}
// ======================================================================================
void InsertRecord(object sender, GridRecordEventArgs e)
{
OtdNam = Convert.ToString(e.Record["OTDNAM"]);
// строка соединение
string connectionString = WebConfigurationManager.ConnectionStrings[MdbNam].ConnectionString;
SqlConnection con = new SqlConnection(connectionString);
con.Open();
// создание команды
SqlCommand cmd = new SqlCommand("ComSprOtdAdd", con);
cmd = new SqlCommand("ComSprOtdAdd", con);
// указать тип команды
cmd.CommandType = CommandType.StoredProcedure;
// создать коллекцию параметров
cmd.Parameters.Add("@BUXSID", SqlDbType.VarChar).Value = BuxSid;
cmd.Parameters.Add("@BUXFRM", SqlDbType.VarChar).Value = BuxFrm;
cmd.Parameters.Add("@OTDNAM", SqlDbType.VarChar).Value = OtdNam;
// ------------------------------------------------------------------------------заполняем второй уровень
cmd.ExecuteNonQuery();
con.Close();
// ------------------------------------------------------------------------------заполняем второй уровень
getGrid();
}
void DeleteRecord(object sender, GridRecordEventArgs e)
{
OrgKod = Convert.ToInt32(e.Record["ORGKOD"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSprOrgDel(MdbNam, BuxSid, OrgKod);
getGrid();
}
void UpdateCustomer(object sender, GridRecordEventArgs e)
{
// try to update the customer
// ...
// throw an exception if something goes wrong
throw new Exception("An error occured when trying to update the customer.");
}
void InsertOrder(object sender, GridRecordEventArgs e)
{
// try to insert the order
// ...
// throw an exception if something goes wrong
throw new Exception("An error occured when trying to insert the order.");
}
public void InsertRecord(object sender, GridRecordEventArgs e)
{
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/Northwind.mdb"));
myConn.Open();
OleDbCommand myComm = new OleDbCommand("INSERT INTO Orders (ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry, Sent, OrderDate, RequiredDate, ShippedDate, ShipVia, AdditionalInformation, ShipColor) VALUES(@ShipName, @ShipAddress, @ShipCity, @ShipRegion, @ShipPostalCode, @ShipCountry, @Sent, @OrderDate, @RequiredDate, @ShippedDate, @ShipVia, @AdditionalInformation, @ShipColor)", myConn);
myComm.Parameters.Add("@ShipName", OleDbType.VarChar).Value = e.Record["ShipName"];
myComm.Parameters.Add("@ShipAddress", OleDbType.VarChar).Value = e.Record["ShipAddress"];
myComm.Parameters.Add("@ShipCity", OleDbType.VarChar).Value = e.Record["ShipCity"];
myComm.Parameters.Add("@ShipRegion", OleDbType.VarChar).Value = e.Record["ShipRegion"];
myComm.Parameters.Add("@ShipPostalCode", OleDbType.VarChar).Value = e.Record["ShipPostalCode"];
myComm.Parameters.Add("@ShipCountry", OleDbType.VarChar).Value = e.Record["ShipCountry"];
myComm.Parameters.Add("@Sent", OleDbType.Boolean).Value = e.Record["Sent"];
myComm.Parameters.Add("@OrderDate", OleDbType.Date).Value = e.Record["OrderDateFormatted"];
myComm.Parameters.Add("@RequiredDate", OleDbType.Date).Value = e.Record["RequiredDateFormatted"];
myComm.Parameters.Add("@ShippedDate", OleDbType.Date).Value = e.Record["ShippedDateFormatted"];
myComm.Parameters.Add("@ShipVia", OleDbType.Integer).Value = e.Record["ShipVia"];
myComm.Parameters.Add("@AdditionalInformation", OleDbType.VarChar).Value = e.Record["AdditionalInformation"];
myComm.Parameters.Add("@ShipColor", OleDbType.VarChar).Value = e.Record["ShipColor"];
myComm.ExecuteNonQuery();
myConn.Close();
}
void DeleteRecord(object sender, GridRecordEventArgs e)
{
AccIdn = Convert.ToInt32(e.Record["ACCIDN"]);
// строка соединение
string connectionString = WebConfigurationManager.ConnectionStrings[MdbNam].ConnectionString;
// создание соединение Connection
SqlConnection con = new SqlConnection(connectionString);
con.Open();
// создание команды
SqlCommand cmd = new SqlCommand("BuxSprAccDel", con);
cmd = new SqlCommand("BuxSprAccDel", con);
// указать тип команды
cmd.CommandType = CommandType.StoredProcedure;
// создать коллекцию параметров
cmd.Parameters.Add("@BUXSID", SqlDbType.VarChar).Value = BuxSid;
cmd.Parameters.Add("@ACCIDN", SqlDbType.VarChar).Value = AccIdn;
// ------------------------------------------------------------------------------заполняем второй уровень
cmd.ExecuteNonQuery();
con.Close();
getGrid();
}
protected void UpdateRecord(object sender, GridRecordEventArgs e)
{
string status = e.Record["T_Active"].ToString() == "yes" ? "1" : "0";
string id = e.Record["T_ID"].ToString();
bool result = objTeam.UpdateTeamStatus(status, Convert.ToInt32(id));
}
void DeleteRecord2(object sender, GridRecordEventArgs e)
{
NgrIdn = Convert.ToInt32(e.Record["NGRIDN"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSprKdrNgrDel(MdbNam, BuxSid, NgrIdn);
getGrid2();
}
void DeleteRecord(object sender, GridRecordEventArgs e)
{
BuxIdn = Convert.ToInt32(e.Record["UchIdn"]);
// строка соединение
string connectionString = WebConfigurationManager.ConnectionStrings[MdbNam].ConnectionString;
// создание соединение Connection
SqlConnection con = new SqlConnection(connectionString);
con.Open();
// создание команды
SqlCommand cmd = new SqlCommand("DELETE FROM SPRUCH WHERE UCHIDN = @BUXIDN", con);
// cmd = new SqlCommand("ComSprBuxUchRep", con);
// указать тип команды
// cmd.CommandType = CommandType.StoredProcedure;
// создать коллекцию параметров
// cmd.Parameters.Add("@BUXSID", SqlDbType.VarChar).Value = BuxSid;
cmd.Parameters.Add("@BUXIDN", SqlDbType.Int, 4).Value = BuxIdn;
// ------------------------------------------------------------------------------заполняем первый уровень
// создание команды
cmd.ExecuteNonQuery();
con.Close();
// ------------------------------------------------------------------------------заполняем второй уровень
getGrid();
}
void InsertRecord(object sender, GridRecordEventArgs e)
{
// BnkKod = Convert.ToInt32(e.Record["BNKKOD"]);
BnkBin = Convert.ToString(e.Record["BNKBIN"]);
BnkBik = Convert.ToString(e.Record["BNKBIK"]);
BnkNam = Convert.ToString(e.Record["BNKNAM"]);
// строка соединение
string connectionString = WebConfigurationManager.ConnectionStrings[MdbNam].ConnectionString;
// создание соединение Connection
SqlConnection con = new SqlConnection(connectionString);
con.Open();
// создание команды
SqlCommand cmd = new SqlCommand("ComSprBnkAdd", con);
cmd = new SqlCommand("ComSprBnkAdd", con);
// указать тип команды
cmd.CommandType = CommandType.StoredProcedure;
// создать коллекцию параметров
cmd.Parameters.Add("@BUXSID", SqlDbType.VarChar).Value = BuxSid;
cmd.Parameters.Add("@BNKBIN", SqlDbType.VarChar).Value = BnkBin;
cmd.Parameters.Add("@BNKBIK", SqlDbType.VarChar).Value = BnkBik;
cmd.Parameters.Add("@BNKNAM", SqlDbType.VarChar).Value = BnkNam;
// ------------------------------------------------------------------------------заполняем первый уровень
// создание команды
cmd.ExecuteNonQuery();
con.Close();
// ------------------------------------------------------------------------------заполняем второй уровень
getGrid();
}
public void UpdateRecord(object sender, GridRecordEventArgs e)
{
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/Northwind.mdb"));
myConn.Open();
OleDbCommand myComm = new OleDbCommand("UPDATE Orders SET ShipName = @ShipName, ShipAddress=@ShipAddress, ShipCity = @ShipCity, ShipRegion=@ShipRegion, ShipPostalCode=@ShipPostalCode, ShipCountry = @ShipCountry, ShipColor = @ShipColor, Sent = @Sent, OrderDate=@OrderDate, RequiredDate=@RequiredDate, ShippedDate=@ShippedDate, ShipVia=@ShipVia, AdditionalInformation=@AdditionalInformation WHERE OrderID = @OrderID", myConn);
myComm.Parameters.Add("@ShipName", OleDbType.VarChar).Value = e.Record["ShipName"];
myComm.Parameters.Add("@ShipAddress", OleDbType.VarChar).Value = e.Record["ShipAddress"];
myComm.Parameters.Add("@ShipCity", OleDbType.VarChar).Value = e.Record["ShipCity"];
myComm.Parameters.Add("@ShipRegion", OleDbType.VarChar).Value = e.Record["ShipRegion"];
myComm.Parameters.Add("@ShipPostalCode", OleDbType.VarChar).Value = e.Record["ShipPostalCode"];
myComm.Parameters.Add("@ShipCountry", OleDbType.VarChar).Value = e.Record["ShipCountry"];
myComm.Parameters.Add("@ShipColor", OleDbType.VarChar).Value = e.Record["ShipColor"];
myComm.Parameters.Add("@Sent", OleDbType.Boolean).Value = e.Record["Sent"];
myComm.Parameters.Add("@OrderDate", OleDbType.Date).Value = e.Record["OrderDateFormatted"];
myComm.Parameters.Add("@RequiredDate", OleDbType.Date).Value = e.Record["RequiredDateFormatted"];
myComm.Parameters.Add("@ShippedDate", OleDbType.Date).Value = e.Record["ShippedDateFormatted"];
myComm.Parameters.Add("@ShipVia", OleDbType.Integer).Value = e.Record["ShipVia"];
myComm.Parameters.Add("@AdditionalInformation", OleDbType.VarChar).Value = e.Record["AdditionalInformation"];
myComm.Parameters.Add("@OrderID", OleDbType.Integer).Value = e.Record["OrderID"];
myComm.ExecuteNonQuery();
myConn.Close();
}
protected void UpdateRecord(object sender, GridRecordEventArgs e)
{
var alternateText = e.Record["ALTERNATETEXT"].ToString();
var kitCode = e.Record["KITCODE"].ToString();
var itemCode = e.Record["ITEMCODE"].ToString();
var qty = int.Parse(e.Record["QUANTITY"].ToString());
int kitItemid = string.IsNullOrEmpty(e.Record["KITITEMID"].ToString()) ? 0 : int.Parse(e.Record["KITITEMID"].ToString());
using (var sConn = new SqlConnection(connStr))
{
sConn.Open();
var sCmd = new SqlCommand("sp_KitUpdate", sConn);
sCmd.CommandType = CommandType.StoredProcedure;
sCmd.Parameters.Add("@KITCODE", SqlDbType.NVarChar);
sCmd.Parameters.Add("@ALTERNATETEXT", SqlDbType.NVarChar);
sCmd.Parameters.Add("@ITEMCODE", SqlDbType.NVarChar);
sCmd.Parameters.Add("@QTY", SqlDbType.Int);
sCmd.Parameters.Add("@KITITEMID", SqlDbType.Int);
sCmd.Parameters["@KITCODE"].Value = kitCode.ToUpper();
sCmd.Parameters["@ALTERNATETEXT"].Value = alternateText;
sCmd.Parameters["@ITEMCODE"].Value = itemCode;
sCmd.Parameters["@QTY"].Value = qty;
sCmd.Parameters["@KITITEMID"].Value = kitItemid;
var res = sCmd.ExecuteNonQuery();
sConn.Close();
}
}
//============= удаление записи после опроса ===========================================================================================
void DeleteRecord(object sender, GridRecordEventArgs e)
{
GlvDocIdn = Convert.ToInt32(Session["GLVDOCIDN"]);
DtlIdn = Convert.ToInt32(e.Record["DTLIDN"]);
// создание DataSet.
DataSet ds = new DataSet();
// строка соединение
string connectionString = WebConfigurationManager.ConnectionStrings[MdbNam].ConnectionString;
// создание соединение Connection
SqlConnection con = new SqlConnection(connectionString);
// создание команды
SqlCommand cmd = new SqlCommand("BuxPrxDocDtlDel", con);
// указать тип команды
cmd.CommandType = CommandType.StoredProcedure;
// передать параметр
cmd.Parameters.Add("@BUXSID", SqlDbType.VarChar).Value = BuxSid;
cmd.Parameters.Add("@DTLIDN", SqlDbType.Int, 4).Value = DtlIdn;
cmd.Parameters.Add("@GLVDOCIDN", SqlDbType.Int, 4).Value = GlvDocIdn;
con.Open();
try
{
int numAff = cmd.ExecuteNonQuery();
// Получить вновь сгенерированный идентификатор.
}
finally
{
con.Close();
}
// localhost.Service1Soap ws = new localhost.Service1SoapClient();
// ws.AptPrxDtlDel(MdbNam, BuxSid, DtlIdn);
CreateGrid();
}
//============= удаление записи после опроса ===========================================================================================
void DeleteRecord(object sender, GridRecordEventArgs e)
{
string AmbCrdIdn;
AmbCrdIdn = Convert.ToString(e.Record["GRFIDN"]);
string connectionString = WebConfigurationManager.ConnectionStrings[MdbNam].ConnectionString;
// создание соединение Connection
SqlConnection con = new SqlConnection(connectionString);
// создание команды
SqlCommand cmd = new SqlCommand("HspDocAppLstDel", con);
// указать тип команды
cmd.CommandType = CommandType.StoredProcedure;
// передать параметр
cmd.Parameters.Add("@GLVDOCIDN", SqlDbType.VarChar).Value = AmbCrdIdn;
cmd.Parameters.Add("@BUXKOD", SqlDbType.VarChar).Value = BuxKod;
// Выполнить команду
con.Open();
cmd.ExecuteNonQuery();
con.Close();
getGrid();
}
protected void gridM_UpdateCommand(object sender, GridRecordEventArgs e)
{
try
{
string x = "";
oboutGrid_utils o = new oboutGrid_utils();
if (gridM.SelectedRecords != null)
{
int[] recs = GetSelectedRecords(gridM, "studymeassubjID");
x = o.oGrid_UpdateData(e.Record, "tblstudymeassubj", "backend", "dbo", "studymeassubjID", recs);
}
else
{
x = o.oGrid_UpdateData(e.Record, "tblstudymeassubj", "backend", "dbo", "studymeassubjID");
}
}
catch (Exception ex) {
string x = ex.Message;
}
//LoadSubjectInfo(ddlID.SelectedValue);
//gridM.DataBind();
}
//============= изменение записи после опроса ===========================================================================================
void UpdateRecord(object sender, GridRecordEventArgs e)
{
GlvDocIdn = Convert.ToInt32(Session["GLVDOCIDN"]);
DtlIdn = Convert.ToInt32(e.Record["DTLIDN"]);
DtlNam = Convert.ToString(e.Record["DTLNAM"]);
DtlKol = Convert.ToDecimal(e.Record["DTLKOL"]);
DtlEdn = Convert.ToString(e.Record["DTLEDN"]);
DtlZen = Convert.ToDecimal(e.Record["DTLZEN"]);
DtlSum = DtlKol * DtlZen;
DtlIzg = Convert.ToString(e.Record["DTLIZG"]);
if (Convert.ToString(e.Record["DTLSRKSLB"]) == null || Convert.ToString(e.Record["DTLSRKSLB"]) == "")
{
DtlSrkSlb = "";
}
else
{
DtlSrkSlb = Convert.ToDateTime(e.Record["DTLSRKSLB"]).ToString("dd.MM.yyyy");
}
// создание DataSet.
DataSet ds = new DataSet();
// строка соединение
string connectionString = WebConfigurationManager.ConnectionStrings[MdbNam].ConnectionString;
// создание соединение Connection
SqlConnection con = new SqlConnection(connectionString);
// создание команды
SqlCommand cmd = new SqlCommand("BuxPrxDocDtlRep", con);
// указать тип команды
cmd.CommandType = CommandType.StoredProcedure;
// передать параметр
cmd.Parameters.Add("@BUXSID", SqlDbType.VarChar).Value = BuxSid;
cmd.Parameters.Add("@DTLIDN", SqlDbType.Int, 4).Value = DtlIdn;
cmd.Parameters.Add("@DTLNAM", SqlDbType.VarChar).Value = DtlNam;
cmd.Parameters.Add("@DTLKOL", SqlDbType.Decimal).Value = DtlKol;
cmd.Parameters.Add("@DTLEDN", SqlDbType.VarChar).Value = DtlEdn;
cmd.Parameters.Add("@DTLZEN", SqlDbType.Decimal).Value = DtlZen;
cmd.Parameters.Add("@DTLSUM", SqlDbType.Decimal).Value = DtlSum;
cmd.Parameters.Add("@DTLIZG", SqlDbType.VarChar).Value = DtlIzg;
cmd.Parameters.Add("@DTLSRKSLB", SqlDbType.VarChar).Value = DtlSrkSlb;
cmd.Parameters.Add("@GLVDOCIDN", SqlDbType.Int, 4).Value = GlvDocIdn;
con.Open();
try
{
int numAff = cmd.ExecuteNonQuery();
// Получить вновь сгенерированный идентификатор.
}
finally
{
con.Close();
}
// localhost.Service1Soap ws = new localhost.Service1SoapClient();
// ws.AptPrxDtlRep(MdbNam, BuxSid, DtlIdn, DtlNam, DtlKol, DtlEdn, DtlZen, DtlSum, DtlIzg, DtlSrkSlb);
CreateGrid();
}
void DeleteRecord(object sender, GridRecordEventArgs e)
{
IdnSpr = Convert.ToInt32(e.Record["SPRIDN"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSpr000Del(MdbNam, BuxSid, NumSpr, IdnSpr);
getGrid();
}
protected void gridContacts_UpdateCommand(object sender, GridRecordEventArgs e)
{
Hashtable hash = (Hashtable)e.Record;
oboutGrid_utils o = new oboutGrid_utils();
string result = o.oGrid_UpdateData(hash, "tContact", "backend", "ac", "contactID");
}
protected void gridContacts_InsertCommand(object sender, GridRecordEventArgs e)
{
Hashtable hash = (Hashtable)e.Record;
oboutGrid_utils o = new oboutGrid_utils();
string foo = o.oGrid_InsertData(hash, "tContact", "backend", "ac", "contactID", 0);
}
//============= удаление записи после опроса ===========================================================================================
void DeleteRecord(object sender, GridRecordEventArgs e)
{
AmbIdn = Convert.ToInt32(e.Record["AMBIDN"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.AmbCrdTabDel(MdbNam, BuxSid, AmbIdn);
getGrid();
}
protected void GridMeta_Budget_UpdateCommand(object sender, GridRecordEventArgs e)
{
oboutGrid_utils o = new oboutGrid_utils();
Hashtable hash = (Hashtable)e.Record;
string result = o.oGrid_UpdateData(hash, "meta_budget", "backend", "fin", "budgetNbr");
}
void DeleteRecord(object sender, GridRecordEventArgs e)
{
MolIdn = Convert.ToInt32(e.Record["MolIdn"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSprMolDel(MdbNam, BuxSid, MolIdn);
getGrid();
}
protected void gridLogContact_InsertCommand(object sender, GridRecordEventArgs e)
{
oboutGrid_utils o = new oboutGrid_utils();
e.Record["studyID"] = Master.Master_studyID;
o.oGrid_InsertData(e.Record, "tblLogContact", "backend", "dbo", "householdID", GetHouseholdID());
//RefreshGrid(gridLogContact, "hh.spLogContact_by_HouseholdID", Request.QueryString["hhID"]);
}
protected void Grid_MyBudgets_UpdateCommand(object sender, GridRecordEventArgs e)
{
oboutGrid_utils o = new oboutGrid_utils();
Hashtable hash = (Hashtable)e.Record;
string x = o.oGrid_UpdateData(hash, "MyBudget", "backend", "fin", "mybudgetpk");
LoadMyBudgets();
}
void InsertRecord(object sender, GridRecordEventArgs e)
{
MolTab = Convert.ToInt32(e.Record["MolTab"]);
MolOtd = Convert.ToInt32(e.Record["MolOtd"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSprMolAdd(MdbNam, BuxSid, BuxFrm, MolTab, MolOtd);
getGrid();
}
protected void Grid1_UpdateCommand(object sender, GridRecordEventArgs e)
{
string[] rowPosition = e.Record["RowPosition"].ToString().Split('_');
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/MoveOrder.mdb"));
myConn.Open();
string selectQuery = "";
if (rowPosition[1] == "-1")
{
selectQuery = "SELECT TOP 1 OrderID, RowPosition FROM Orders_2 WHERE RowPosition <= @RowPosition AND OrderID <> @OrderID ORDER BY RowPosition DESC";
}
else
{
selectQuery = "SELECT TOP 1 OrderID, RowPosition FROM Orders_2 WHERE RowPosition >= @RowPosition AND OrderID <> @OrderID ORDER BY RowPosition ASC";
}
OleDbCommand myComm = new OleDbCommand(selectQuery, myConn);
myComm.Parameters.Add("@RowPosition", OleDbType.Integer).Value = rowPosition[0];
myComm.Parameters.Add("@OrderID", OleDbType.Integer).Value = e.Record["OrderID"];
OleDbDataReader reader = myComm.ExecuteReader();
if(reader.Read())
{
int toggeledOrderId = reader.GetInt32(0);
int toggeledRowPosition = reader.GetInt32(1);
int orderId = int.Parse(e.Record["OrderID"].ToString());
int oldRowPosition = int.Parse(rowPosition[0]);
OleDbCommand myComm2 = new OleDbCommand("UPDATE Orders_2 SET RowPosition=@RowPosition WHERE OrderID = @OrderID", myConn);
myComm2.Parameters.Add("@RowPosition", OleDbType.Integer).Value = toggeledRowPosition;
myComm2.Parameters.Add("@OrderID", OleDbType.Integer).Value = orderId;
myComm2.ExecuteNonQuery();
OleDbCommand myComm3 = new OleDbCommand("UPDATE Orders_2 SET RowPosition=@RowPosition WHERE OrderID = @OrderID", myConn);
myComm3.Parameters.Add("@RowPosition", OleDbType.Integer).Value = oldRowPosition;
myComm3.Parameters.Add("@OrderID", OleDbType.Integer).Value = toggeledOrderId;
myComm3.ExecuteNonQuery();
Hashtable record = new Hashtable();
record.Add("OrderID", orderId);
record.Add("RowPosition", toggeledRowPosition);
record.Add("ShipName", e.Record["ShipName"].ToString());
record.Add("ShipCity", e.Record["ShipCity"].ToString());
record.Add("ShipPostalCode", e.Record["ShipPostalCode"].ToString());
record.Add("ShipCountry", e.Record["ShipCountry"].ToString());
Grid1.SelectedRecords.Add(record);
}
myConn.Close();
}
protected void DeleteRecord(object sender, GridRecordEventArgs e)
{
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/Northwind.mdb"));
myConn.Open();
OleDbCommand myComm = new OleDbCommand("DELETE FROM Orders WHERE OrderID = @OrderID", myConn);
myComm.Parameters.Add("@OrderID", OleDbType.Integer).Value = e.Record["OrderID"];
myComm.ExecuteNonQuery();
myConn.Close();
}
public void InsertRecord(object sender, GridRecordEventArgs e)
{
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/Northwind.mdb"));
myConn.Open();
OleDbCommand myComm = new OleDbCommand("INSERT INTO Orders (ShipName, AdditionalInformation) VALUES(@ShipName, @AdditionalInformation)", myConn);
myComm.Parameters.Add("@ShipName", OleDbType.VarChar).Value = e.Record["ShipName"];
myComm.Parameters.Add("@AdditionalInformationHTML", OleDbType.VarChar).Value = e.Record["AdditionalInformationHTML"];
myComm.ExecuteNonQuery();
myConn.Close();
}
public void UpdateRecord(object sender, GridRecordEventArgs e)
{
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/Northwind.mdb"));
myConn.Open();
OleDbCommand myComm = new OleDbCommand("UPDATE Orders SET ShipName = @ShipName, AdditionalInformationHTML=@AdditionalInformationHTML WHERE OrderID = @OrderID", myConn);
myComm.Parameters.Add("@ShipName", OleDbType.VarChar).Value = e.Record["ShipName"];
myComm.Parameters.Add("@AdditionalInformationHTML", OleDbType.VarChar).Value = e.Record["AdditionalInformationHTML"];
myComm.Parameters.Add("@OrderID", OleDbType.Integer).Value = e.Record["OrderID"];
myComm.ExecuteNonQuery();
myConn.Close();
}
public void UpdateRecord(object sender, GridRecordEventArgs e)
{
using (SqlConnection cnx = new SqlConnection(ConfigurationManager.ConnectionStrings["conexionAPPS"].ToString()))
{
cnx.Open();
string query = " UPDATE AUD_C_CURSOS set descripcion_curso=@descripcioncurso, vencimiento_curso=@vencimientocurso" +
" WHERE id_curso=@idcurso ";
SqlCommand cmd = new SqlCommand(query, cnx);
cmd.Parameters.AddWithValue("@idcurso", e.Record["id_curso"]);
cmd.Parameters.AddWithValue("@descripcioncurso", e.Record["descripcion_curso"]);
cmd.Parameters.AddWithValue("@vencimientocurso", e.Record["vencimiento_curso"]);
SqlDataReader dr = cmd.ExecuteReader();
} // cierre de la conn
Grid1.AllowGrouping = true;
Grid1.GroupBy = "vencimiento_curso";
}
protected void UpdateRecord(object sender, GridRecordEventArgs e)
{
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/Northwind.mdb"));
myConn.Open();
OleDbCommand myComm = new OleDbCommand("UPDATE Orders SET ShipName = @ShipName, ShipCountry = @ShipCountry, ShipCity = @ShipCity, ShipPostalCode=@ShipPostalCode WHERE OrderID = @OrderID", myConn);
myComm.Parameters.Add("@ShipName", OleDbType.VarChar).Value = e.Record["ShipName"];
myComm.Parameters.Add("@ShipCountry", OleDbType.VarChar).Value = e.Record["ShipCountry"];
myComm.Parameters.Add("@ShipCity", OleDbType.VarChar).Value = e.Record["ShipCity"];
myComm.Parameters.Add("@ShipPostalCode", OleDbType.VarChar).Value = e.Record["ShipPostalCode"];
myComm.Parameters.Add("@OrderID", OleDbType.Integer).Value = e.Record["OrderID"];
myComm.ExecuteNonQuery();
myConn.Close();
}
public void DeleteRecord(object sender, GridRecordEventArgs e)
{
using (SqlConnection cnx = new SqlConnection(ConfigurationManager.ConnectionStrings["conexionAPPS"].ToString()))
{
cnx.Open();
string query = "DELETE FROM AUD_EXPEDIENTE WHERE doc_IdArchivo=@doc_IdArchivo ";
SqlCommand cmd = new SqlCommand(query, cnx);
cmd.Parameters.AddWithValue("@doc_IdArchivo", e.Record["doc_IdArchivo"]);
SqlDataReader dr = cmd.ExecuteReader();
} // cierre de la conn
grid3.AllowGrouping = true;
grid3.GroupBy = "doc_tipo";
//busco el archivo a borrar en el directorio
//using (SqlConnection cnx = new SqlConnection(ConfigurationManager.ConnectionStrings["conexionAPPS"].ToString()))
//{
// cnx.Open();
// string query = " SELECT doc_IdArchivo, doc_nombre, doc_ruta, doc_IdEmpleado, doc_tipo, doc_subtipo, doc_agrupador, doc_Mes, doc_anio, doc_descripcion, doc_alta " +
// " FROM AUD_EXPEDIENTE " +
// " WHERE (doc_IdArchivo = @doc_IdArchivo ) ";
// SqlCommand cmd = new SqlCommand(query, cnx);
// cmd.Parameters.AddWithValue("@doc_IdArchivo", e.Record["doc_IdArchivo"]);
// SqlDataReader dr = cmd.ExecuteReader();
// if (dr.HasRows)
// {
// while (dr.Read())
// {
// diastranscurridos.Text = dr["diastranscurridos"].ToString();
// idestatus.Text = dr["estatus"].ToString();
// }
// }
// else
// {
// opcion.Text = "nuevo";
// }
//} // cierre de la conn
// Directory.Delete(yourDirectory); para eliminar archivo
}
protected void InsertRecord(object sender, GridRecordEventArgs e)
{
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/Northwind.mdb"));
myConn.Open();
OleDbCommand myComm = new OleDbCommand("INSERT INTO Orders (ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry, Sent, OrderDate, RequiredDate, ShippedDate, ShipVia, AdditionalInformation) VALUES(@ShipName, @ShipAddress, @ShipCity, @ShipRegion, @ShipPostalCode, @ShipCountry, @Sent, @OrderDate, @RequiredDate, @ShippedDate, @ShipVia, @AdditionalInformation)", myConn);
myComm.Parameters.Add("@ShipName", OleDbType.VarChar).Value = e.Record["ShipName"];
myComm.Parameters.Add("@ShipAddress", OleDbType.VarChar).Value = e.Record["ShipAddress"];
myComm.Parameters.Add("@ShipCity", OleDbType.VarChar).Value = e.Record["ShipCity"];
myComm.Parameters.Add("@ShipRegion", OleDbType.VarChar).Value = e.Record["ShipRegion"];
myComm.Parameters.Add("@ShipPostalCode", OleDbType.VarChar).Value = e.Record["ShipPostalCode"];
myComm.Parameters.Add("@ShipCountry", OleDbType.VarChar).Value = e.Record["ShipCountry"];
myComm.Parameters.Add("@Sent", OleDbType.Boolean).Value = e.Record["Sent"];
myComm.Parameters.Add("@OrderDate", OleDbType.Date).Value = e.Record["OrderDateFormatted"];
myComm.Parameters.Add("@RequiredDate", OleDbType.Date).Value = e.Record["RequiredDateFormatted"];
myComm.Parameters.Add("@ShippedDate", OleDbType.Date).Value = e.Record["ShippedDateFormatted"];
myComm.Parameters.Add("@ShipVia", OleDbType.Integer).Value = e.Record["ShipVia"];
myComm.Parameters.Add("@AdditionalInformation", OleDbType.VarChar).Value = e.Record["AdditionalInformation"];
myComm.ExecuteNonQuery();
myConn.Close();
}
protected void InsertRecord(object sender, GridRecordEventArgs e)
{
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/Northwind.mdb"));
myConn.Open();
OleDbCommand myComm = new OleDbCommand("INSERT INTO Orders (ShipName, ShipCountry, ShipCity, ShipPostalCode) VALUES(@ShipName, @ShipCountry, @ShipCity, @ShipPostalCode)", myConn);
myComm.Parameters.Add("@ShipName", OleDbType.VarChar).Value = e.Record["ShipName"];
myComm.Parameters.Add("@ShipCountry", OleDbType.VarChar).Value = e.Record["ShipCountry"];
myComm.Parameters.Add("@ShipCity", OleDbType.VarChar).Value = e.Record["ShipCity"];
myComm.Parameters.Add("@ShipPostalCode", OleDbType.VarChar).Value = e.Record["ShipPostalCode"];
myComm.ExecuteNonQuery();
myConn.Close();
}
void DeleteRecord(object sender, GridRecordEventArgs e)
{
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/Northwind.mdb"));
myConn.Open();
OleDbCommand myComm = new OleDbCommand("DELETE FROM Orders WHERE OrderID = " + e.Record["OrderID"].ToString(), myConn);
myComm.ExecuteNonQuery();
myConn.Close();
}
void InsertRecord(object sender, GridRecordEventArgs e)
{
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/Northwind.mdb"));
myConn.Open();
OleDbCommand myComm = new OleDbCommand("INSERT INTO Orders (ShipName, ShipCity, ShipCountry) VALUES('" + e.Record["ShipName"].ToString().Replace("'", "''") + "', '" + e.Record["ShipCity"].ToString().Replace("'", "''") + "', '" + e.Record["ShipCountry"].ToString().Replace("'", "''") + "')", myConn);
myComm.ExecuteNonQuery();
myConn.Close();
}
void UpdateRecord(object sender, GridRecordEventArgs e)
{
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/Northwind.mdb"));
myConn.Open();
OleDbCommand myComm = new OleDbCommand("UPDATE Orders SET ShipName='" + e.Record["ShipName"].ToString().Replace("'", "''") + "', ShipCity='" + e.Record["ShipCity"].ToString().Replace("'", "''") + "', ShipCountry='" + e.Record["ShipCountry"].ToString().Replace("'", "''") + "' WHERE OrderID = " + e.Record["OrderID"].ToString(), myConn);
myComm.ExecuteNonQuery();
myConn.Close();
}
protected void Grid1_InsertCommand(object sender, GridRecordEventArgs e)
{
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/categories.mdb"));
OleDbCommand myComm = new OleDbCommand("INSERT INTO Categories(ParentID, CategoryText, Description, DateAdded, PriceRange) VALUES(@ParentID, @CategoryText, @Description, @DateAdded, @PriceRange)", myConn);
myComm.Parameters.Add("@ParentID", OleDbType.Integer).Value = e.Record["ParentID"];
myComm.Parameters.Add("@CategoryText", OleDbType.VarChar).Value = e.Record["CategoryText"];
myComm.Parameters.Add("@Description", OleDbType.VarChar).Value = e.Record["Description"];
myComm.Parameters.Add("@DateAdded", OleDbType.Date).Value = e.Record["DateAdded"];
myComm.Parameters.Add("@PriceRange", OleDbType.VarChar).Value = e.Record["PriceRange"];
myConn.Open();
myComm.ExecuteNonQuery();
myConn.Close();
}
protected void Grid1_UpdateCommand(object sender, GridRecordEventArgs e)
{
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/categories.mdb"));
OleDbCommand myComm = new OleDbCommand("UPDATE Categories SET CategoryText=@CategoryText, Description=@Description, DateAdded=@DateAdded, PriceRange=@PriceRange WHERE CategoryID=@CategoryID", myConn);
myComm.Parameters.Add("@CategoryText", OleDbType.VarChar).Value = e.Record["CategoryText"];
myComm.Parameters.Add("@Description", OleDbType.VarChar).Value = e.Record["Description"];
myComm.Parameters.Add("@DateAdded", OleDbType.Date).Value = e.Record["DateAdded"];
myComm.Parameters.Add("@PriceRange", OleDbType.VarChar).Value = e.Record["PriceRange"];
myComm.Parameters.Add("@CategoryID", OleDbType.Integer).Value = e.Record["CategoryID"];
myConn.Open();
myComm.ExecuteNonQuery();
myConn.Close();
}
public void DeleteRecord(object sender, GridRecordEventArgs e)
{
string ruta="";
string fileName = "";
using (SqlConnection cnx = new SqlConnection(ConfigurationManager.ConnectionStrings["conexionAPPS"].ToString()))
{
cnx.Open();
string query = " SELECT doc_IdArchivo, doc_nombre, doc_ruta, doc_IdEmpleado, doc_tipo, doc_subtipo, doc_agrupador, " +
" doc_Mes, doc_anio, doc_descripcion, doc_ruta+doc_nombre as rutacompleta " +
" FROM AUD_EXPEDIENTE " +
" WHERE (doc_IdEmpleado = @id_empleado) and doc_id_curso=@doc_idcurso ";
SqlCommand cmd = new SqlCommand(query, cnx);
cmd.Parameters.AddWithValue("@id_empleado", e.Record["id_empleado"]);
cmd.Parameters.AddWithValue("@doc_idcurso", e.Record["id_curso"]);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
ruta = dr["rutacompleta"].ToString();
fileName = dr["doc_nombre"].ToString();
//RutArchivo = "Documentos/Expedientes/";
//RutArchivodestino = "Documentos/Expedientes/Expedientes_eliminados/";
// -------muevo los archivos fisicos a la carpeta Expedientes_eliminados
//string fileName = "archivo.text";
string sourcePath = HttpContext.Current.Server.MapPath(ruta);
//string targetPath = @"Documentos\Expedientes\Expedientes_eliminados\";
string targetPath = HttpContext.Current.Server.MapPath("/Expedientes/Expedientes_eliminados/");
// Use Path class to manipulate file and directory paths.
string sourceFile = System.IO.Path.Combine(sourcePath);
string destFile = System.IO.Path.Combine(targetPath, fileName);
// To copy a folder's contents to a new location:
// Create a new target folder, if necessary.
try
{
if (!System.IO.Directory.Exists(targetPath))
{
System.IO.Directory.CreateDirectory(targetPath);
}
}
catch (FileNotFoundException ex)
{
etiquetaMensajeErrorFiltros.Text = ex.Message;
return;
}
//if (System.IO.Directory.Exists(sourcePath))
//{
// To copy a file to another location and
// overwrite the destination file if it already exists.
System.IO.File.Copy(sourceFile, destFile, true);
// To copy all the files in one directory to another directory.
// Get the files in the source folder. (To recursively iterate through
// all subfolders under the current directory, see
// "How to: Iterate Through a Directory Tree.")
// Note: Check for target path was performed previously
// in this code example.
Boolean existe_arc_fisico = false;
try
{
existe_arc_fisico = System.IO.Directory.Exists(sourcePath);
}
catch (FileNotFoundException ex)
{
etiquetaMensajeErrorFiltros.Text = ex.Message;
return;
}
if (existe_arc_fisico)
{
try
{
string[] files = System.IO.Directory.GetFiles(sourcePath);
// Copy the files and overwrite destination files if they already exist.
foreach (string s in files)
{
// Use static Path methods to extract only the file name from the path.
fileName = System.IO.Path.GetFileName(s);
destFile = System.IO.Path.Combine(targetPath, fileName);
System.IO.File.Copy(s, destFile, true);
}
}
catch (System.IO.IOException ex)
{
etiquetaMensajeErrorFiltros.Text = ex.Message;
return;
}
}
else
{
etiquetaMensajeErrorFiltros.Text = "Source path does not exist!";
}
//ELIMINO ARCHIVO FISICAMENTE DEL DIRECTORIO
try
{
System.IO.File.Delete(HttpContext.Current.Server.MapPath(ruta));
}
catch (System.IO.IOException ex)
{
etiquetaMensajeErrorFiltros.Text = ex.Message;
return;
}
}
} // del while de capacitacion
//}
}
// ELIMINO DE AUD_EXPEDIENTE
using (SqlConnection cnx = new SqlConnection(ConfigurationManager.ConnectionStrings["conexionAPPS"].ToString()))
{
cnx.Open();
string query = "DELETE FROM AUD_EXPEDIENTE WHERE doc_idempleado=@id_empleado and doc_id_curso=@doc_idcurso";
SqlCommand cmd = new SqlCommand(query, cnx);
cmd.Parameters.AddWithValue("@id_empleado", e.Record["id_empleado"]);
cmd.Parameters.AddWithValue("@doc_idcurso", e.Record["id_curso"]);
SqlDataReader dr = cmd.ExecuteReader();
} // cierre de la conn
// ELIMINO DE AUD_D_CAPACITACION
using (SqlConnection cnx = new SqlConnection(ConfigurationManager.ConnectionStrings["conexionAPPS"].ToString()))
{
cnx.Open();
string query = "DELETE FROM AUD_D_CAPACITACION WHERE id_empleado=@idempleado and id_curso=@idcurso";
SqlCommand cmd = new SqlCommand(query, cnx);
cmd.Parameters.AddWithValue("@idempleado", e.Record["id_empleado"]);
cmd.Parameters.AddWithValue("@idcurso", e.Record["id_curso"]);
SqlDataReader dr = cmd.ExecuteReader();
} // cierre de la conn
CreateGrid();
}
protected void Grid1_Select(object sender, GridRecordEventArgs e)
{
}
