public void OnDeleteCommandExecute(object obj)
{
string role_id = "";
try
{
System.Data.DataRow dataRow = ((System.Data.DataRowView)_colView.CurrentItem).Row;
role_id = dataRow["role_id"].ToString();
dataRow.Delete();
}
catch
{
}
try
{
DataTable dt = roleEventData.employee_role_event; //posParamData.pos_param;
foreach (DataRow dr in dt.Rows)
{
if (string.Equals(dr["role_id"].ToString(), role_id))
{
dr.Delete();
}
}
}
catch
{
}
}
private void get_gd_cc(DataSet v_ds_gdd, ref decimal v_count, DataRow v_data_row, ref int v_int_khong_nhap_duoc, DataRow v_dt_r)
{
DataRow v_dt_gdd = v_ds_gdd.Tables[0].Rows[0];
decimal v_id_gdd = CIPConvert.ToDecimal(v_dt_gdd["ID"].ToString());
US_GD_CHUNG_CHI v_us_gdcc = new US_GD_CHUNG_CHI();
v_us_gdcc.dcID_GD_DIEM = v_id_gdd;
v_us_gdcc.strSO_CHUNG_CHI = v_data_row["SO_CHUNG_CHI"].ToString();
v_us_gdcc.datNGAY_CAP = (DateTime)v_data_row["NGAY_CAP"];
v_us_gdcc.datNGAY_BAT_DAU = (DateTime)v_data_row["NGAY_BAT_DAU"];
if (v_data_row["NGAY_KET_THUC"].ToString() == "")
{
v_us_gdcc.IsNGAY_KET_THUCNull();
}
else
{
v_us_gdcc.datNGAY_KET_THUC = (DateTime)v_data_row["NGAY_KET_THUC"];
}
v_us_gdcc.datNGAY_LAP = DateTime.Now.Date;
v_us_gdcc.datNGAY_SUA = DateTime.Now.Date;
v_us_gdcc.strDA_XOA = "N";
try
{
v_us_gdcc.Insert();
v_data_row.Delete();
v_count++;
}
catch (Exception)
{
MessageBox.Show("Chứng chỉ "+ v_us_gdcc.strSO_CHUNG_CHI+ " đã tồn tại. Vui lòng kiểm tra lại thông tin!");
v_int_khong_nhap_duoc++;
}
}
public void OnDeleteCommandExecute(object obj)
{
int deleteConfigNo = 0;
try
{
System.Data.DataRow dataRow = ((System.Data.DataRowView)_colView.CurrentItem).Row;
deleteConfigNo = int.Parse(dataRow["config_no"].ToString());
dataRow.Delete();
}
catch
{
}
try
{
DataTable dt = posParamData.pos_param;
foreach (DataRow dr in dt.Rows)
{
if (int.Parse(dr["config_no"].ToString()) == deleteConfigNo)
{
dr.Delete();
}
}
}
catch
{
}
}
public static Boolean DeleteDrinkTypeRow(DataRow drinkTypeRow)
{
var productExists = DataBaseProducerDrinkHelper.GetProducerDrinkData().Any(product => product.id_rodzaju_napoju == (drinkTypeRow as HurtowniaNapojowDataSet.RodzajeNapojuRow).Identyfikator);
if (productExists)
{
MessageBox.Show("Do wybranego rodzaju napoju '" + (drinkTypeRow as HurtowniaNapojowDataSet.RodzajeNapojuRow).NazwaRodzajuNapoju + "' są przypisane napoje producenta. Rodzaj napoju nie zostanie usunięty.", Globals.TITLE_ERROR);
return false;
}
drinkTypeRow.Delete();
return DrinkTypeTableAdapter.Update(drinkTypeRow) == 1;
}
public static Boolean DeleteCustomerRow(DataRow customerRow)
{
var shoppingExists = DataBaseShoppingHelper.GetShoppingData().Any(shopping => shopping.id_klienta == (customerRow as HurtowniaNapojowDataSet.KlienciRow).Identyfikator);
if (shoppingExists)
{
MessageBox.Show("Do wybranego klienta '" + (customerRow as HurtowniaNapojowDataSet.KlienciRow).NazwaKlienta + "' są przypisane zakupy klienta. Klient nie zostanie usunięty.", Globals.TITLE_ERROR);
return false;
}
customerRow.Delete();
return CustomerTableAdapter.Update(customerRow) == 1;
}
public static Boolean DeletePiecePackageRow(DataRow piecePackageRow)
{
var productExists = DataBaseProducerDrinkHelper.GetProducerDrinkData().Any(product => product.id_opakowania_sztuki == (piecePackageRow as HurtowniaNapojowDataSet.OpakowaniaSztukiRow).Identyfikator);
if (productExists)
{
HurtowniaNapojowDataSet.NazwyOpakowaniaSztukiRow tempPiecePackageName = DataBasePiecePackageNameHelper.GetPiecePackageNameByID((piecePackageRow as HurtowniaNapojowDataSet.OpakowaniaSztukiRow).id_rodzaju_opakowania_sztuki);
MessageBox.Show("Do wybranego rodzaju opakowania sztuki '"+tempPiecePackageName.NazwaOpakowania+", "+ (piecePackageRow as HurtowniaNapojowDataSet.OpakowaniaSztukiRow).Pojemność + "' są przypisane napoje producenta. Rodzaj opakowania sztuki nie zostanie usunięty.", Globals.TITLE_ERROR);
return false;
}
piecePackageRow.Delete();
return PiecePackageTableAdapter.Update(piecePackageRow) == 1;
}
public static Boolean DeleteBulkPackageRow(DataRow bulkPackageRow)
{
var productExists = DataBaseProducerDrinkHelper.GetProducerDrinkData().Any(product => product.id_opakowania_zbiorczego == (bulkPackageRow as HurtowniaNapojowDataSet.OpakowaniaZbiorczeRow).Identyfikator);
if (productExists)
{
HurtowniaNapojowDataSet.NazwyOpakowaniaZbiorczegoRow tempBulkPackageName = DataBaseBulkPackageNameHelper.GetBulkPackageNameByID((bulkPackageRow as HurtowniaNapojowDataSet.OpakowaniaZbiorczeRow).id_rodzaju_opakowania_zbiorczego);
MessageBox.Show("Do wybranego rodzaju opakowania zbiorczego '" + tempBulkPackageName.NazwaOpakowania + ", " + (bulkPackageRow as HurtowniaNapojowDataSet.OpakowaniaZbiorczeRow).Pojemność + "' są przypisane napoje producenta. Rodzaj opakowania zbiorczego nie zostanie usunięty.", Globals.TITLE_ERROR);
return false;
}
bulkPackageRow.Delete();
return BulkPackageTableAdapter.Update(bulkPackageRow) == 1;
}
public static Boolean DeleteDrinkNameRow(DataRow drinkNameRow)
{
var productExists = DataBaseProducerDrinkHelper.GetProducerDrinkData().Any(product => product.id_nazwy_napoju == (drinkNameRow as HurtowniaNapojowDataSet.NazwyNapojuRow).Identyfikator);
if (productExists)
{
MessageBox.Show("Do wybranej nazwy napoju '" + (drinkNameRow as HurtowniaNapojowDataSet.NazwyNapojuRow).NazwaNapoju + "' są przypisane napoje producenta. Nazwa napoju nie zostanie usunięta.", Globals.TITLE_ERROR);
return false;
}
drinkNameRow.Delete();
var result = DrinkNameTableAdapter.Update(drinkNameRow) == 1;
if (result) RefreshData();
return result;
}
public static Boolean DeleteTasteRow(DataRow tasteRow)
{
var productExists = DataBaseProducerDrinkHelper.GetProducerDrinkData().Any(product => product.id_smaku == (tasteRow as HurtowniaNapojowDataSet.SmakiRow).Identyfikator);
if (productExists)
{
MessageBox.Show("Do wybranego smaku '" + (tasteRow as HurtowniaNapojowDataSet.SmakiRow).NazwaSmaku + "' są przypisane napoje producenta. Smak nie zostanie usunięty.", Globals.TITLE_ERROR);
return false;
}
tasteRow.Delete();
var result = TasteTableAdapter.Update(tasteRow) == 1;
if (result) RefreshData();
return result;
}
public static Boolean DeleteProducerDrinkRow(DataRow producerDrinkRow)
{
var warehouseProductExists = DataBaseWarehouseDrinkHelper.GetWarehouseDrinkData().Any(product => product.id_napoju_producenta == (producerDrinkRow as HurtowniaNapojowDataSet.NapojeProducentaRow).Identyfikator);
if (warehouseProductExists)
{
MessageBox.Show("Do wybranego napoju producenta są przypisane napoje hurtowni. Wybrany napój producenta nie zostanie usunięty.", Globals.TITLE_ERROR);
return false;
}
producerDrinkRow.Delete();
var result = ProducerDrinkTableAdapter.Update(producerDrinkRow) == 1;
if (result) RefreshData();
return result;
}
public static Boolean DeleteGasTypeRow(DataRow gasTypeRow)
{
var productExists = DataBaseProducerDrinkHelper.GetProducerDrinkData().Any(product => product.id_rodzaju_gazu == (gasTypeRow as HurtowniaNapojowDataSet.RodzajeGazuRow).Identyfikator);
if (productExists)
{
MessageBox.Show("Do wybranego rodzaju gazu '" + (gasTypeRow as HurtowniaNapojowDataSet.RodzajeGazuRow).NazwaRodzaju + "' są przypisane napoje producenta. Rodzaj Gazu nie zostanie usunięty.", Globals.TITLE_ERROR);
return false;
}
gasTypeRow.Delete();
var result = GasTypeTableAdapter.Update(gasTypeRow) == 1;
if (result) RefreshData();
return result;
}
public static Boolean DeleteProducerRow(DataRow producerRow)
{
var productExists = DataBaseProducerDrinkHelper.GetProducerDrinkData().Any(product => product.id_procuenta == (producerRow as HurtowniaNapojowDataSet.ProducenciRow).Identyfikator);
if (productExists)
{
MessageBox.Show("Do wybranego producenta '" + (producerRow as HurtowniaNapojowDataSet.ProducenciRow).NazwaProducenta + "' są przypisane napoje producenta. Wybrany Producent nie zostanie usunięty.", Globals.TITLE_ERROR);
return false;
}
producerRow.Delete();
var result = ProducerTableAdapter.Update(producerRow) == 1;
if (result) RefreshData();
return result;
}
public static Boolean DeletePiecePackageNameRow(DataRow piecePackageNameRow)
{
var piecePackageExists = DataBasePiecePackageHelper.GetPiecePackageData().Any(piecePackage => piecePackage.id_rodzaju_opakowania_sztuki == (piecePackageNameRow as HurtowniaNapojowDataSet.NazwyOpakowaniaSztukiRow).Identyfikator);
if (piecePackageExists)
{
MessageBox.Show("Do wybranej nazwy rodzaju opakowania sztuki '" + (piecePackageNameRow as HurtowniaNapojowDataSet.NazwyOpakowaniaSztukiRow).NazwaOpakowania + "' są przypisane opakowania sztuki. Nazwa rodzaju opakowania sztuki nie zostanie usunięta.", Globals.TITLE_ERROR);
return false;
}
piecePackageNameRow.Delete();
var result = PiecePackageNameTableAdapter.Update(piecePackageNameRow) == 1;
if (result) RefreshData();
return result;
}
public static Boolean DeleteWarehouseDrinkRow(DataRow warehouseDrinkRow)
{
var warehouseProductExists = DataBaseProductHelper.GetProductsData().Any(product => product.id_napoju_hurtowni == (warehouseDrinkRow as HurtowniaNapojowDataSet.NapojeHurtowniRow).Identyfikator);
if (warehouseProductExists)
{
MessageBox.Show("Do wybranego napoju z magazynu są przypisane produkty zakópów klienta. Wybrana pozycja magazynu nie zostanie usunięta.", Globals.TITLE_ERROR);
return false;
}
warehouseDrinkRow.Delete();
var result = WarehouseDrinkTableAdapter.Update(warehouseDrinkRow) == 1;
if (result) RefreshData();
return result;
}
} // initStdField
/// <summary>
///
/// </summary>
/// <param name="ctx">Current Ctx of an application</param>
/// <param name="iWindowId">window number</param>
/// <param name="dr">Datarow contating resultset</param>
/// <returns></returns>
public static GridFieldVO CreateParameter(Ctx t_ctx, int iWindowId, System.Data.DataRow dr)
{
GridFieldVO vo = new GridFieldVO(t_ctx, iWindowId, 0, 0, 0, false);
vo.isProcess = true;
vo.IsDisplayedf = true;
vo.IsReadOnly = false;
vo.IsUpdateable = true;
try
{
vo.AD_Table_ID = 0;
vo.AD_Column_ID = int.Parse(dr["AD_Process_Para_ID"].ToString());
vo.ColumnName = dr["COLUMNNAME"].ToString();
vo.Header = dr["Name"].ToString();
vo.name = dr["Name"].ToString();
vo.Description = dr["Description"].ToString();
vo.Help = dr["Help"].ToString();
vo.displayType = int.Parse(dr["AD_Reference_ID"].ToString());
vo.AD_Reference_ID = int.Parse(dr["AD_Reference_ID"].ToString());
vo.IsMandatoryUI = dr["IsMandatoryUI"].ToString() == "Y" ? true : false;
vo.FieldLength = int.Parse(dr["FIELDLENGTH"].ToString());
vo.DisplayLength = vo.FieldLength;
vo.DefaultValue = dr["DefaultValue"].ToString();
vo.DefaultValue2 = dr["DEFAULTVALUE2"].ToString();
vo.ValueMin = dr["VALUEMIN"].ToString();
vo.ValueMax = dr["VALUEMAX"].ToString();
vo.isRange = dr["ISRANGE"].ToString() == "Y";
vo.AD_Reference_Value_ID = int.Parse((dr["AD_REFERENCE_VALUE_ID"].ToString() == "") ? "0" : dr["AD_REFERENCE_VALUE_ID"].ToString());
vo.ValidationCode = dr["VALIDATIONCODE"].ToString();
vo.AD_InfoWindow_ID = Util.GetValueOfInt(dr["AD_INFOWINDOW_ID"]);
vo.LoadRecursiveData = dr["LoadRecursiveData"].ToString() == "Y" ? true : false;
vo.ShowChildOfSelected = dr["ShowChildOfSelected"].ToString() == "Y" ? true : false;
//Check If parameter is marked encrypted or not.
vo.IsEncryptedField = dr["IsEncrypted"].ToString() == "Y" ? true : false;
dr.Delete();
}
catch
{
}
vo.InitFinish();
return(vo);
}
public static Boolean DeleteBulkPackageNameRow(DataRow bulkPackageNameRow)
{
var bulkPackageExists = DataBaseBulkPackageHelper.GetBulkPackageData().Any(bulk => bulk.id_rodzaju_opakowania_zbiorczego == (bulkPackageNameRow as HurtowniaNapojowDataSet.NazwyOpakowaniaZbiorczegoRow).Identyfikator);
if (bulkPackageExists)
{
MessageBox.Show("Do wybranej nazwy rodzaju opakowania zbiorczego '" + (bulkPackageNameRow as HurtowniaNapojowDataSet.NazwyOpakowaniaZbiorczegoRow).NazwaOpakowania + "' są przypisane opakowania zbiorcze. Nazwa opakowania zbiorczego nie zostanie usunięta.", Globals.TITLE_ERROR);
return false;
}
try
{
bulkPackageNameRow.Delete();
var result = BulkPackageNameTableAdapter.Update(bulkPackageNameRow) == 1;
if (result) RefreshData();
return result;
}
catch (OleDbException e)
{
MessageBox.Show(e.Message, Globals.TITLE_ERROR);
return false;
}
}
internal void Push(CUQueue UQueue, DataRow dr)
{
int n;
bool bNull;
if (dr == null)
throw new ArgumentNullException("Datarow object can't be null");
if (m_dts == null)
throw new ArgumentNullException("DataTable header is not serialized yet");
if (m_dts.Length != dr.ItemArray.Length)
throw new InvalidOperationException("The size of the input data type array does not match the size of data row");
byte b = 0;
byte bOne = 1;
m_qBit.SetSize(0);
m_qTemp.SetSize(0);
bool bDelete = (dr.RowState == DataRowState.Deleted);
if (bDelete)
dr.RejectChanges();
object[] data = dr.ItemArray;
int nLen = m_dts.Length;
for (n = 0; n < nLen; n++)
{
object myData = data[n];
bNull = (myData == null || myData.Equals(DBNull.Value));
if (bNull)
{
b += (byte)(bOne << (byte)(n % 8));
}
if ((n % 8) == 7)
{
m_qBit.Save(b);
b = 0;
}
if (bNull)
continue;
switch (m_dts[n])
{
case tagDataTypeSupported.dtBoolean:
m_qTemp.Save((bool)myData);
break;
case tagDataTypeSupported.dtByte:
m_qTemp.Save((byte)myData);
break;
case tagDataTypeSupported.dtChar:
m_qTemp.Save((char)myData);
break;
case tagDataTypeSupported.dtDateTime:
m_qTemp.Save((DateTime)myData);
break;
case tagDataTypeSupported.dtDecimal:
m_qTemp.Save((decimal)myData);
break;
case tagDataTypeSupported.dtDouble:
m_qTemp.Save((double)myData);
break;
case tagDataTypeSupported.dtFloat:
m_qTemp.Save((float)myData);
break;
case tagDataTypeSupported.dtGuid:
m_qTemp.Save((Guid)myData);
break;
case tagDataTypeSupported.dtUInt16:
m_qTemp.Save((ushort)myData);
break;
case tagDataTypeSupported.dtUInt32:
m_qTemp.Save((uint)myData);
break;
case tagDataTypeSupported.dtUInt64:
m_qTemp.Save((ulong)myData);
break;
case tagDataTypeSupported.dtInt16:
m_qTemp.Save((short)myData);
break;
case tagDataTypeSupported.dtInt32:
m_qTemp.Save((int)myData);
break;
case tagDataTypeSupported.dtInt64:
m_qTemp.Save((long)myData);
break;
case tagDataTypeSupported.dtString:
m_qTemp.Save((string)myData);
break;
case tagDataTypeSupported.dtValue:
case tagDataTypeSupported.dtValues:
case tagDataTypeSupported.dtChars:
case tagDataTypeSupported.dtBytes:
case tagDataTypeSupported.dtTimeSpan:
m_qTemp.Save(myData, false, false);
break;
case tagDataTypeSupported.dtUDT:
m_qTemp.Save(myData.ToString());
break;
default:
throw new InvalidOperationException("Unsupported data type for serialization");
}
}
if ((n % 8) != 0)
m_qBit.Save(b);
UQueue.Push(m_qBit.m_bytes, m_qBit.GetSize());
UQueue.Push(m_qTemp.m_bytes, m_qTemp.GetSize());
if (bDelete)
dr.Delete();
UQueue.Save((byte)dr.RowState);
UQueue.Save(dr.HasErrors);
if (dr.HasErrors)
UQueue.Save(dr.RowError);
}
private bool UpdateRow(DataTable tbl, DataRow row, int nLastVer, DateTime dtLock, DateTime dtUnLock, bool bLock)
{
int val = 0;
try
{
if (bLock)
{
row.BeginEdit();
row["fieldid"] = m_nFieldID;
row["modtabID"] = m_nModTabID;
row["tablename"] = m_strTableName;
row["fieldname"] = m_strFieldName;
row["lastversion"] = nLastVer;
row["lockip"] = m_strIP;
row["lockhostname"] = m_strHostName;
row["lockusername"] = m_strHostName;
if (dtLock == DateTime.MinValue)
row["locktime"] = DBNull.Value;
else
row["locktime"] = dtLock;
if (dtUnLock == DateTime.MinValue)
row["unlocktime"] = DBNull.Value;
else
row["unlocktime"] = dtUnLock;
row.EndEdit();
}
else
{
row.Delete();
}
SqlCommandBuilder cmdBuilder = m_cmdBuilder;// new SqlCommandBuilder(m_adp);
m_adp.UpdateCommand = cmdBuilder.GetUpdateCommand();
val = m_adp.Update(tbl);
tbl.AcceptChanges();
return val > 0;
}
catch (Exception ex)
{
tbl.RejectChanges();
throw ex;
}
}
public void DeleteFilterX(DataRow filterX)
{
string str = filterX["ID"].ToString();
string sql = "delete from " + this._tblfiltername + " where ID='" + str + "';\ndelete from " + this._tblFilterConditionName + " where Filter_Id='" + str + "';";
QueryHelper.ExecuteSqlScalar("SkyMap.Net.Criteria", sql);
this.DeleteFilterXConditions(filterX);
filterX.Delete();
}
internal void GetEntityFromDataRow(DataColumnCollection columnCollection, DataRow row, IOfflineEntity objectToConvert)
{
Type t = objectToConvert.GetType();
Dictionary<string, string> mappingInfo = _localToGlobalPropertyMapping[t];
bool isDeleted = false;
if (row.RowState == DataRowState.Deleted)
{
isDeleted = true;
row.RejectChanges();
}
// Note: Call BeginEdit only after check for Deleted row state,
// otherwise this call will crash.
row.BeginEdit();
for (Int32 i = 0; i <= columnCollection.Count - 1; i++)
{
if (IsSyncSpecificColumn(columnCollection[i].ColumnName))
{
continue;
}
//NOTE: the datarow column names must match exactly (including case) to the IOfflineEntity's property names
object columnValue = row[columnCollection[i].ColumnName];
if (DBNull.Value != columnValue)
{
t.InvokeMember((mappingInfo.ContainsKey(columnCollection[i].ColumnName))
? mappingInfo[columnCollection[i].ColumnName]
: columnCollection[i].ColumnName,
BindingFlags.SetProperty, null,
objectToConvert,
new[] {columnValue});
}
}
if (isDeleted)
{
row.Delete();
// Mark the IsTombstone field if the RowState was deleted.
objectToConvert.ServiceMetadata.IsTombstone = true;
}
row.EndEdit();
}
private void deleteTicket(DataRow dr)
{
String tid = DrGetStr(dr, this.gxxfDataSet.Ticket.TicketIdColumn);
dr.Delete();
ticketTableAdapter.Update(dr);
DataRow[] rows = gxxfDataSet.TicketJacket.Select("TicketId = '" + tid + "'");
foreach (DataRow r in rows) {
r.Delete();
ticketJacketTableAdapter.Update(r);
}
rows = gxxfDataSet.TicketTrousers.Select("TicketId = '" + tid + "'");
foreach (DataRow r in rows) {
r.Delete();
ticketTrousersTableAdapter.Update(r);
}
}
protected void dgvDetReq_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
tbldetalle = (DataTable)Session["CARRITO"];
switch (e.CommandName)
{
case "Eliminar":
string codigo = e.CommandArgument.ToString();
dr = tbldetalle.Rows.Find(Convert.ToString(codigo));
dr.Delete();
tbldetalle.AcceptChanges();
CalcularTotal();
Session["CARRITO"] = tbldetalle;
dgvDetReq.DataSource = tbldetalle;
dgvDetReq.DataBind();
break;
}
}
catch { }
}
public void removeCategoria(DataRow catDel)
{
const string mensagem =
"Tem certeza de que deseja excluir esta categoria?";
const string titulo = "Aviso";
var result = MessageBox.Show(mensagem, titulo,
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
int id = int.Parse(listViewCategorias.SelectedItems[0].Tag.ToString());
SqlCommand comandoUpdate = new SqlCommand();
SqlCommand comandoAchaSemCategoria = new SqlCommand();
comandoUpdate.Connection = conexaoFinanceiro;
comandoAchaSemCategoria.Connection = conexaoFinanceiro;
comandoAchaSemCategoria.CommandText =
("Select ID_CATEGORIA From CATEGORIA where NOME = 'Sem Categoria'");
int idSemCategoria = (int)comandoAchaSemCategoria.ExecuteScalar();
comandoUpdate.CommandText =
("Update Movimento set id_categoria = " + idSemCategoria + " where id_categoria = " + id);
comandoUpdate.ExecuteNonQuery();
catDel.Delete();
adaptadorCategoria.Update(dadosFinanceiro, "Categoria");
adaptadorMovimento.Update(dadosFinanceiro, "Movimento");
carregaMovimentos();
carregaCategorias();
}
}
public void removeMovimento(DataRow movDel)
{
const string mensagem =
"Tem certeza de que deseja excluir a movimentação?";
const string titulo = "Aviso";
var result = MessageBox.Show(mensagem, titulo,
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
movDel.Delete();
adaptadorMovimento.Update(dadosFinanceiro, "Movimento");
carregaMovimentos();
}
}
public static IEnumerable<IEditorScript> GetScripts(IAsyncConnection conn, string type, string id
, string relatedId = null, DataRow row = null)
{
if (!string.IsNullOrEmpty(id))
{
ArasMetadataProvider metadata = null;
ItemType itemType = null;
if (conn != null)
{
metadata = ArasMetadataProvider.Cached(conn);
itemType = metadata.ItemTypeByName(type);
}
if (metadata != null)
{
yield return new EditorScript()
{
Name = "View \"" + (itemType.Label ?? itemType.Name) + "\"",
Action = "ApplyItem",
Script = string.Format("<Item type='{0}' id='{1}' action='get' levels='1'></Item>", type, id),
AutoRun = true,
PreferredOutput = OutputType.Table
};
if (!string.IsNullOrEmpty(relatedId) && itemType.Related != null)
{
yield return new EditorScript()
{
Name = "View \"" + (itemType.Related.Label ?? itemType.Related.Name) + "\"",
Action = "ApplyItem",
Script = string.Format("<Item type='{0}' id='{1}' action='get' levels='1'></Item>", itemType.Related.Name, relatedId),
AutoRun = true,
PreferredOutput = OutputType.Table
};
}
}
yield return new EditorScript()
{
Name = "------"
};
if (conn != null)
{
yield return ArasEditorProxy.ItemTypeAddScript(conn, itemType);
}
if (row == null)
{
yield return new EditorScript()
{
Name = "Edit",
Action = "ApplyItem",
Script = string.Format("<Item type='{0}' id='{1}' action='edit'></Item>", type, id)
};
yield return new EditorScript()
{
Name = "Delete",
Action = "ApplyItem",
Script = string.Format("<Item type='{0}' id='{1}' action='delete'></Item>", type, id)
};
}
else
{
yield return new EditorScriptExecute()
{
Name = "Delete",
Execute = () => row.Delete()
};
}
yield return new EditorScript()
{
Name = "------"
};
if (metadata != null)
{
var actions = new EditorScript()
{
Name = "Actions"
};
var serverActions = metadata.ServerItemActions(type)
.OrderBy(l => l.Label ?? l.Value, StringComparer.CurrentCultureIgnoreCase)
.ToArray();
foreach (var action in serverActions)
{
actions.Add(new EditorScript()
{
Name = (action.Label ?? action.Value),
Action = "ApplyItem",
Script = string.Format("<Item type='{0}' id='{1}' action='{2}'></Item>", type, id, action.Value),
AutoRun = true
});
}
if (serverActions.Any())
yield return actions;
var reports = new EditorScript()
{
Name = "Reports"
};
var serverReports = metadata.ServerReports(type)
.OrderBy(l => l.Label ?? l.Value, StringComparer.CurrentCultureIgnoreCase)
.ToArray();
foreach (var report in serverReports)
{
reports.Add(new EditorScript()
{
Name = (report.Label ?? report.Value),
Action = "ApplyItem",
Script = @"<Item type='Method' action='Run Report'>
<report_name>" + report.Value + @"</report_name>
<AML>
<Item type='" + itemType.Name + "' typeId='" + itemType.Id + "' id='" + id + @"' />
</AML>
</Item>",
AutoRun = true
});
}
if (serverReports.Any())
yield return reports;
}
yield return new EditorScriptExecute()
{
Name = "Copy ID",
Execute = () =>
{
if (string.IsNullOrEmpty(id))
{
System.Windows.Clipboard.Clear();
}
else
{
System.Windows.Clipboard.SetText(id);
}
}
};
}
}
//-------------------------------------------------------------------------------------------
// Suppress an entry from the database
//-------------------------------------------------------------------------------------------
internal static void ManualDelete(DataRow row, bool removefromDb, bool deletefromStorage)
{
LogMyFilms.Info("Manual_Delete(): remove from DB = '" + removefromDb + "', delete from storage = '" + deletefromStorage + "'");
if (deletefromStorage)
{
var newItems = new ArrayList();
bool noResumeMovie = true;
int movieIndex = 0;
SearchAllFiles(row, true, ref noResumeMovie, ref newItems, ref movieIndex, false, "");
foreach (object t in from object t in newItems where File.Exists(t.ToString()) select t)
{
// for each entry test if it's a file, a directory or a dvd copy
// no action for files on removible media or image files
try
{
File.Delete(t.ToString());
LogMyFilms.Info("file deleted : " + t);
}
catch (Exception ex)
{
LogMyFilms.Info("unable to delete file : " + t);
LogMyFilms.InfoException("Manual_Delete() - delete file exception: ", ex);
}
}
}
if (removefromDb)
{
string wdelTitle = row[MyFilms.conf.StrTitle1].ToString();
//AntMovieCatalog.MovieRow RowToDelete = row;
//foreach (AntMovieCatalog.CustomFieldsRow customFieldsRow in RowToDelete.GetCustomFieldsRows())
//{
// customFieldsRow.Delete();
//}
row.Delete();
LogMyFilms.Info("Database movie deleted : " + wdelTitle);
Update_XML_database();
}
}
//-------------------------------------------------------------------------------------------
// Suppress an entry from the database
//-------------------------------------------------------------------------------------------
private static void SuppressEntry(DataRow row)
{
if (MyFilms.conf.StrSuppressAutomaticActionType == "2" || MyFilms.conf.StrSuppressAutomaticActionType == "4")
{
var newItems = new ArrayList();
bool noResumeMovie = true;
int movieIndex = 0;
SearchAllFiles(row, true, ref noResumeMovie, ref newItems, ref movieIndex, false, "");
foreach (object t in from object t in newItems where File.Exists(t.ToString()) select t)
{
try
{
File.Delete(t.ToString());
LogMyFilms.Info("file deleted : " + t);
}
catch
{
LogMyFilms.Info("unable to delete file : " + t);
}
}
}
if (MyFilms.conf.StrSuppressAutomaticActionType == "1" || MyFilms.conf.StrSuppressAutomaticActionType == "2")
{
string wdelTitle = row[MyFilms.conf.StrTitle1].ToString();
row.Delete();
MyFilms.conf.StrIndex = -1;
LogMyFilms.Info("Database movie deleted : " + wdelTitle);
}
// Update_XML_database(); // already done on calling method ...
}
/// <summary>
/// Removes the specified DataRow from the collection.
/// </summary>
public void Remove (DataRow row)
{
if (IndexOf (row) < 0)
throw new IndexOutOfRangeException ("The given datarow is not in the current DataRowCollection.");
DataRowState state = row.RowState;
if (state != DataRowState.Deleted && state != DataRowState.Detached) {
row.Delete ();
// if the row was in added state it will be in Detached state after the
// delete operation, so we have to check it.
if (row.RowState != DataRowState.Detached)
row.AcceptChanges ();
}
}
public void RemoveRow(DataRow selectedRow)
{
selectedRow.Delete();
Update(selectedRow.GetType());
AcceptChanges();
}
private void DeleteTheWholeChain (DataTable AllSecureableUnits, DataRow ToDelete)
{
String ID = ToDelete ["ID"].ToString();
DataRow [] Children = AllSecureableUnits.Select ("ParentID = '" + ID + "'");
foreach (DataRow Child in Children)
{
DeleteTheWholeChain(AllSecureableUnits, Child);
Child.Delete();
AllSecureableUnits.AcceptChanges();
}
String DeleteStatement = "Delete SecureableUnits where ParentID = '" + ID + "'";
AltErlaaInfoDataAccess.RunSQLBatch (DeleteStatement);
ToDelete.Delete();
AllSecureableUnits.AcceptChanges();
}
/// <summary>
/// This method will try to locate the passed in DataRow's key values in the destination DataTable
/// and if found will update its values with the new values passed.
/// </summary>
/// <param name="destinationTable">Table to make the merge in</param>
/// <param name="rowToMatch">Row whose keys to match in destination table</param>
/// <param name="rowvalues">Values to override</param>
/// <param name="entityType">Entity type for the DataRow</param>
internal void MergeChangeInToDataSet(DataTable destinationTable, DataRow rowToMatch, object[] rowvalues, Type entityType)
{
object[] primaryKeyColumns = new object[destinationTable.PrimaryKey.Length];
int index = 0;
bool isRowToMatchDeleted = false;
if (rowToMatch.RowState == DataRowState.Deleted)
{
isRowToMatchDeleted = true;
rowToMatch.RejectChanges();
}
// Find all PrimaryKey column indexes
foreach (DataColumn pkColumn in destinationTable.PrimaryKey)
{
primaryKeyColumns[index++] = rowToMatch[pkColumn.ColumnName];
}
// Find the row in DestinationTable
DataRow rowToModify = destinationTable.Rows.Find(primaryKeyColumns);
// Check for tombstones
bool isRowDeleted = false;
if (rowToModify.RowState == DataRowState.Deleted)
{
isRowDeleted = true;
rowToModify.RejectChanges();
}
// Suppress DataRow RowChanging events
// Note: Call BeginEdit only after check for Deleted row state,
// otherwise this call will crash.
rowToModify.BeginEdit();
Debug.Assert(rowToModify != null);
rowToModify.ItemArray = rowvalues;
// Reset rowstates
if (isRowDeleted)
{
rowToModify.Delete();
}
if (isRowToMatchDeleted)
{
rowToMatch.Delete();
}
rowToModify.EndEdit();
}
private static void DeleteRow(DataRow row)
{
try
{
row.Delete();
}
catch (Exception ex)
{
string s = Error.GetErrorMessage(ex, false, false);
MessageBox.Show(s, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void get_id_gd_diem(US_DUNG_CHUNG v_us_dc, decimal v_id_ns, decimal v_id_gdlm, DataRow v_dt_r, ref int v_int_khong_nhap_duoc, DataRow v_data_row, ref decimal v_count)
{
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us_dc.FillDatasetWithQuery(v_ds, "SELECT * FROM GD_DIEM WHERE ID_NHAN_VIEN=" + v_id_ns.ToString() + " AND ID_LOP_MON=" + v_id_gdlm.ToString());
if (v_ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Nhân viên này chưa có tên trong lớp môn này");
}
v_dt_r = v_ds.Tables[0].Rows[0];
decimal v_id_gdd = CIPConvert.ToDecimal(v_dt_r["ID"].ToString());
US_GD_DIEM v_us_gdd = new US_GD_DIEM(v_id_gdd);
if (v_us_gdd.dcDIEM_CHUYEN_CAN.ToString() == "")
{
v_us_gdd.IsDIEM_CHUYEN_CANNull();
}
else
{
v_us_gdd.dcDIEM_CHUYEN_CAN = CIPConvert.ToDecimal(v_data_row["DIEM_CHUYEN_CAN"].ToString());
}
if (v_us_gdd.dcDIEM_THI.ToString() == "")
{
v_us_gdd.IsDIEM_THINull();
}
else
{
v_us_gdd.dcDIEM_THI = CIPConvert.ToDecimal(v_data_row["DIEM_KIEM_TRA"].ToString());
}
if (v_us_gdd.dcDIEM_KIEM_TRA.ToString()=="")
{
v_us_gdd.IsDIEM_KIEM_TRANull();
}
else
{
v_us_gdd.dcDIEM_KIEM_TRA = CIPConvert.ToDecimal(v_data_row["DIEM_THI"].ToString());
}
v_us_gdd.strQUA_MON = v_data_row["KET_QUA"].ToString();
v_us_gdd.datNGAY_SUA = DateTime.Now.Date;
v_us_gdd.strHOC_XONG_YN = "Y";
v_us_gdd.Update();
try
{
v_us_gdd.Update();
v_data_row.Delete();
v_count++;
}
catch (Exception)
{
MessageBox.Show("Lỗi!");
v_int_khong_nhap_duoc++;
}
}
