public int UpdateRow(DbTransaction pTran, WorkField WorkField, bool CreateTransaction)
{
int intRow = 0;
DbTransaction objTran = pTran;
Exception exception = null;
try
{
if (pTran == null && CreateTransaction == true)
{
objTran = WorkFieldData.CreateTransaction();
}
intRow = WorkFieldData.UpdateRow(objTran, WorkField);
if (pTran == null && objTran != null && CreateTransaction == true)
{
WorkFieldData.CommitTransaction(objTran, true);
objTran = null;
}
}
catch (Exception EX)
{
exception = EX;
if (pTran == null && objTran != null && CreateTransaction == true)
{
WorkFieldData.RollbackTransaction(objTran, true);
objTran = null;
}
}
finally
{
}
return(intRow);
}
private static WorkFieldDTO mapWorkField(WorkField workField)
{
WorkFieldDTO _WorkFieldMap = new WorkFieldDTO();
_WorkFieldMap = fillWorkFieldDTObyWorkFieldID(workField.Id);
// _WorkFieldMap.WorkFieldDTO = fillWorkfieldDTObyCustomerID(workField.Id);
return(_WorkFieldMap);;
}
public int DeleteRow(DbTransaction pTran, WorkField WorkField)
{
int intRows = 0;
DbParameter[] Parameters = new DbParameter[1];
Parameters[0] = _getIdParameter(WorkField.Id, ParameterDirection.Input);
intRows = ExecuteNonQuery(pTran, "[Lookups].[DeleteWorkField]", Parameters);
return(intRows);
}
public WorkFieldList SelectRows(DbTransaction pTran, System.Int32?Id, System.String name, System.String nameAr)
{
WorkFieldList WorkFieldList = new WorkFieldList();
Exception exception = null;
DbParameter[] Parameters = new DbParameter[3];
Parameters[0] = _getIdParameter(Id, ParameterDirection.Input);
Parameters[1] = _getnameParameter(name, ParameterDirection.Input);
Parameters[2] = _getnameArParameter(nameAr, ParameterDirection.Input);
DbDataReader Dr = ExecuteReader(pTran, "[Lookups].[SelectWorkField]", Parameters);
try
{
if (Dr != null)
{
while (Dr.Read())
{
WorkField WorkField = new WorkField();
if (Dr["Id"] != DBNull.Value)
{
WorkField.Id = (System.Int32)Dr["Id"];
}
if (Dr["name"] != DBNull.Value)
{
WorkField.name = (System.String)Dr["name"];
}
if (Dr["nameAr"] != DBNull.Value)
{
WorkField.nameAr = (System.String)Dr["nameAr"];
}
WorkFieldList.FillRow(WorkField);
WorkField = null;
}
}
}
catch (Exception Ex)
{
exception = Ex;
}
finally
{
if (Dr != null)
{
if (Dr.IsClosed == false)
{
Dr.Close();
}
Dr = null;
}
}
return(WorkFieldList);
}
public int UpdateRow(DbTransaction pTran, WorkField WorkField)
{
int intRows = 0;
DbParameter[] Parameters = new DbParameter[3];
Parameters[0] = _getIdParameter(WorkField.Id, ParameterDirection.Input);
Parameters[1] = _getnameParameter(WorkField.name, ParameterDirection.Input);
Parameters[2] = _getnameArParameter(WorkField.nameAr, ParameterDirection.Input);
intRows = ExecuteNonQuery(pTran, "[Lookups].[UpdateWorkField]", Parameters);
return(intRows);
}
private static WorkFieldDTO fillWorkfieldDTObyCustomerID(int id)
{
WorkFieldDTO workFieldDTO = default(WorkFieldDTO); //new WorkFieldDTO();
WorkField _WorkField = _WorkFieldList.FirstOrDefault(i => i.Id == id);
if (_WorkField != default(WorkField))
{
workFieldDTO = new WorkFieldDTO();
workFieldDTO.Id = _WorkField.Id;
workFieldDTO.name = _WorkField.name;
workFieldDTO.nameAr = _WorkField.nameAr;
}
return(workFieldDTO);
}
private static WorkFieldDTO fillWorkFieldDTObyWorkFieldID(int?WorkFieldID)
{
{
WorkFieldDTO _WorkFieldDTO = default(WorkFieldDTO);
WorkField _WorkField = _WorkFieldList.FirstOrDefault(i => i.Id == WorkFieldID.Value);
if (_WorkField != default(WorkField))
{
_WorkFieldDTO = new WorkFieldDTO();
_WorkFieldDTO.Id = _WorkField.Id;
_WorkFieldDTO.name = _WorkField.name;
_WorkFieldDTO.nameAr = _WorkField.nameAr;
}
return(_WorkFieldDTO);
}
}
public int InsertRow(DbTransaction pTran, WorkField WorkField)
{
int intRows = 0;
DbParameter[] Parameters = new DbParameter[3];
Parameters[0] = _getIdParameter(WorkField.Id, ParameterDirection.Output);
Parameters[1] = _getnameParameter(WorkField.name, ParameterDirection.Input);
Parameters[2] = _getnameArParameter(WorkField.nameAr, ParameterDirection.Input);
intRows = ExecuteNonQuery(pTran, "[Lookups].[InsertWorkField]", Parameters);
if (Parameters[0].Value != DBNull.Value)
{
WorkField.Id = (System.Int32)Parameters[0].Value;
}
return(intRows);
}
public static bool MapWorkFieldAsInput(WorkFieldDTO workFieldDTO)
{
bool result = default(bool);
_WorkField = new WorkField();
if (workFieldDTO != null)
{
// WorkField Data part
_WorkField.Id = workFieldDTO.Id;
_WorkField.name = workFieldDTO.name;
_WorkField.nameAr = workFieldDTO.nameAr;
result = true;
}
return(result);
}
public int DeleteRow(WorkField WorkField)
{
DbTransaction Tran = null;
return(DeleteRow(Tran, WorkField));
}
public int UpdateRow(WorkField WorkField)
{
DbTransaction Tran = null;
return(UpdateRow(Tran, WorkField));
}
public int InsertRow(WorkField WorkField)
{
DbTransaction Tran = null;
return(InsertRow(Tran, WorkField));
}
private void DropSelectedIcon()
{
if (currentElement != null || ChangeWorkField != null)
{
DBRepository <Elements> dBRepository = new DBRepository <Elements>(new BuildEntities());
try
{
if (Choose && !Change)
{
int x = (int)CursorPoint.X - (int)CurrentElement.Size / 2;
int y = (int)CursorPoint.Y;
WorkField workField = new WorkField
{
Element_ID = CurrentElement.ID,
Rotate = 0,
PositionX = x,
PositionY = y
};
if (CurrentProject != null)
{
workField.ID_UP = CurrentProject.ID;
}
HomeCollection.Add(new HomeElements(workField, dBRepository.GetAll().Where(s => s.ID == CurrentElement.ID).First()));
Choose = false;
Change = false;
ChangeWorkField = null;
TotalPrice = (Convert.ToDecimal(TotalPrice) + (decimal)CurrentElement.Price).ToString();
BackHistory.History.Push(HomeCollection.ToList());
if (BackHistory.History.Count() > 30)
{
BuildHistory helpstack = new BuildHistory();
foreach (var item in BackHistory.History)
{
if (helpstack.History.Count < 30)
{
helpstack.History.Push(item);
}
}
BackHistory.History.Clear();
foreach (var item in helpstack.History)
{
BackHistory.History.Push(item);
}
}
}
else if (Choose && Change)
{
HomeCollection.Remove(ChangeWorkField);
int x = (int)CursorPoint.X - (int)ChangeWorkField.Element.Size / 2;
int y = (int)CursorPoint.Y;
ChangeWorkField.Field.PositionX = x;
ChangeWorkField.Field.PositionY = y;
HomeCollection.Add(ChangeWorkField);
Choose = false;
Change = false;
ChangeWorkField = null;
}
}
catch { }
dBRepository.Dispose();
}
}
public int UpdateRow(DbTransaction pTran, WorkField WorkField)
{
return(UpdateRow(pTran, WorkField, false));
}
public int InsertRow(DbTransaction pTran, WorkField WorkField)
{
return(InsertRow(pTran, WorkField, false));
}
public int DeleteRow(DbTransaction pTran, WorkField WorkField)
{
return(DeleteRow(pTran, WorkField, false));
}
