public Task <bool> Update(dto_grant_type_updateC _dto)
{
bool _updated = false;
if (string.IsNullOrEmpty(_dto.grant_type_name))
{
AddErrorMessage("Update Error", "Save Error", "Grant Type Name Is Null!");
return(Task.FromResult(_updated));
}
if (fnn.LOGGED_USER.DoesNotHaveRight(em.right_menu_types.can_edit_grant_info))
{
_updated = false;
AddErrorMessage("Limited Rights Error", "Limited Rights Error", "You Are Not Authorized To Perform This Operation");
return(Task.FromResult(_updated));
}
using (var _trans = new ZUpdateContext())
{
var _existing = _trans.Context.GRANT_TYPES.Where(e => e.grant_type_id == _dto.grant_type_id & e.delete_id == 0).FirstOrDefault();
if (_existing == null)
{
_updated = false;
AddErrorMessage("Update Error", "Save Error", "Unable To Find Grant Type Object");
return(Task.FromResult(_updated));
}
if (_existing.grant_type_name.ToLower() != _dto.grant_type_name.ToLower())
{
var _ret = DbHelper.UpdatePrimaryKeyColumn(new DbHelperPrimarykeyUpdateC
{
col_to_update = "grant_type_name",
new_col_value = _dto.grant_type_name.Trim().ToProperCase(),
table_name = DbHelper.GetTableSchemaName(_table_name),
pk_col_name = "grant_type_id",
pk_id = _dto.grant_type_id
}, _trans.Context);
if (_ret == null || _ret.Value == false)
{
AddErrorMessage("Error", "Update Error", "Grant Type Name Already Exists");
_updated = false;
return(Task.FromResult(_updated));
}
else
{
_updated = true;
_trans.Context.SaveChanges();
_trans.Commit();
}
}
_updated = true;
if (_updated)
{
List <DbParameter> _para = new List <DbParameter>();
_para.Clear();
int _cat_type_id = em.resource_cat_typeS.grant_type.ToInt32();
var _r_list = (from k in _trans.Context.VOICE_RESOURCE_CATEGORIES
where k.resource_cat_type_id == _cat_type_id & k.resource_cat_id == _existing.grant_type_id
& k.delete_id == 0
select k).ToList();
foreach (var _v in _r_list)
{
_para.Clear();
_para.Add(fnn.GetDbParameters("@v1", _existing.grant_type_id));
_para.Add(fnn.GetDbParameters("@v2", fnn.GetServerDate().ToUnixTimestamp()));
_para.Add(fnn.GetDbParameters("@v3", System.DBNull.Value));
_para.Add(fnn.GetDbParameters("@v4", _dto.grant_type_name.Trim().ToProperCase()));
var _sql = string.Format(string.Format("update {0} set fs_timestamp=@v2,resource_cat_img_url=@v3" +
",resource_cat_name=@v4 where un_id = @v1 and delete_id = 0", DbHelper.GetTableSchemaName("voice_resource_cat_tb")));
_trans.Context.Database.ExecuteSqlCommand(_sql, _para.ToArray());
_trans.Context.SaveChanges();
}
}
}
return(Task.FromResult(_updated));
}
public Task <fuel_stationC> Update(dto_fuel_station_updateC _dto)
{
fuel_stationC _existing = null;
if (_dto == null)
{
AddErrorMessage("Update Error", "Save Error", "Fuel Station Object Is Null!");
_existing = null;
return(Task.FromResult(_existing));
}
if (_dto.fuel_station_id == 0)
{
AddErrorMessage("Error", "Error", "Fuel Station Id Is Missing");
return(Task.FromResult(_existing));
}
if (string.IsNullOrEmpty(_dto.fuel_station_name))
{
AddErrorMessage("Error", "Error", "Fuel Station Name Is Missing");
return(Task.FromResult(_existing));
}
try
{
using (var _trans = new ZUpdateContext())
{
_existing = _trans.Context.FUEL_STATIONS.Where(e => e.fuel_station_id == _dto.fuel_station_id & e.delete_id == 0).FirstOrDefault();
if (_existing == null)
{
_existing = null;
AddErrorMessage("Update Error", "Save Error", "Unable To Find Fuel Station Object");
return(Task.FromResult(_existing));
}
if (_existing.fuel_station_name.ToLower() != _dto.fuel_station_name.ToLower())
{
var _ret = DbHelper.UpdatePrimaryKeyColumn(new DbHelperPrimarykeyUpdateC
{
col_to_update = "fuel_station_name",
new_col_value = _dto.fuel_station_name.Trim().ToProperCase(),
table_name = DbHelper.GetTableSchemaName(_table_name),
pk_col_name = "fuel_station_id",
pk_id = _dto.fuel_station_id
}, _trans.Context);
if (_ret == null || _ret.Value == false)
{
AddErrorMessage("Error", "Update Error", "Fuel Station Name Already Exists");
_existing = null;
_trans.RollBack();
return(Task.FromResult(_existing));
}
else
{
_trans.Context.SaveChanges();
_existing = _trans.Context.FUEL_STATIONS.Where(e => e.fuel_station_id == _dto.fuel_station_id & e.delete_id == 0).FirstOrDefault();
}
}
SimpleMapper.PropertyMap(_dto, _existing);
if (_existing.cr_account_id > 0)
{
string _sql = string.Format("update {0} set cr_account_name=@v1,cr_phone_no=@v2,fs_timestamp=@v3 where cr_account_id=@v4 and delete_id=0",
FleetManager.DbBase.tableNames.creditor_tb.ToDbSchemaTable());
_trans.Context.Database.Connection.Execute(_sql, new
{
v1 = _existing.fuel_station_name,
v2 = string.Empty,
v3 = fnn.GetUnixTimeStamp(),
v4 = _existing.cr_account_id
}, _trans.Context.Database.GetDbTransaction());
_trans.Context.SaveChanges();
}
_trans.Context.FUEL_STATIONS.AddOrUpdateExtension(_existing);
_trans.Context.SaveChanges();
_trans.Commit();
return(Task.FromResult(_existing));
}
}
catch (SqlException ex)
{
LoggerX.LogException(ex);
}
catch (DbException ex)
{
LoggerX.LogException(ex);
}
catch (Exception ex)
{
LoggerX.LogException(ex);
}
return(Task.FromResult(_existing));
}
public Task <vh_expense_typeC> Update(dto_expense_type_updateC _dto)
{
vh_expense_typeC _existing = null;
if (fnn.LOGGED_USER.DoesNotHaveRight(em.user_rights_types.can_edit_expense_type))
{
_existing = null;
AddErrorMessage("Limited Rights Error", "Rights Error", "You Can Not Perform This Operation");
return(Task.FromResult(_existing));
}
if (string.IsNullOrEmpty(_dto.exp_type_name))
{
AddErrorMessage("Update Error", "Save Error", "Expense Type Name Is Null!");
return(Task.FromResult(_existing));
}
try
{
using (var _trans = new ZUpdateContext())
{
_existing = _trans.Context.EXPENSE_TYPES.Where(e => e.exp_type_id == _dto.exp_type_id & e.delete_id == 0).FirstOrDefault();
if (_existing == null)
{
AddErrorMessage("Update Error", "Save Error", "Unable To Find Expense Type Object");
return(Task.FromResult(_existing));
}
if (_existing.exp_type_id < 0)
{
AddErrorMessage("Update Error", "Update Error", "Cannot Update A System Defined Expense Type");
return(Task.FromResult(_existing));
}
if (_existing.exp_type_name.ToLower() != _dto.exp_type_name.ToLower())
{
var _ret = DbHelper.UpdatePrimaryKeyColumn(new DbHelperPrimarykeyUpdateC
{
col_to_update = "exp_type_name",
new_col_value = _dto.exp_type_name.Trim().ToProperCase(),
table_name = DbHelper.GetTableSchemaName(_table_name),
pk_col_name = "exp_type_id",
pk_id = _dto.exp_type_id
}, _trans.Context);
if (_ret == null || _ret.Value == false)
{
AddErrorMessage("Error", "Update Error", "Expense Type Name Already Exists");
_trans.RollBack();
return(Task.FromResult(_existing));
}
else
{
_trans.Context.SaveChanges();
_existing = _trans.Context.EXPENSE_TYPES.Where(e => e.exp_type_id == _dto.exp_type_id & e.delete_id == 0).FirstOrDefault();
}
}
SimpleMapper.PropertyMap(_dto, _existing);
_trans.Context.EXPENSE_TYPES.AddOrUpdateExtension(_existing);
_trans.Context.SaveChanges();
_trans.Commit();
return(Task.FromResult(_existing));
}
}
catch (SqlException ex)
{
LoggerX.LogException(ex);
}
catch (DbException ex)
{
LoggerX.LogException(ex);
}
catch (Exception ex)
{
LoggerX.LogException(ex);
}
return(Task.FromResult(_existing));
}
public Task <List <vh_expense_transC> > AddExpense(dto_expense_trans_voucher_newC _dto)
{
List <vh_expense_transC> _list = null;
if (fnn.LOGGED_USER.DoesNotHaveRight(em.user_rights_types.can_create_vehicle_expense))
{
AddErrorMessage("Limited Rights Error", "Rights Error", "You Can Not Perform This Operation");
return(Task.FromResult(_list));
}
if (_dto == null)
{
AddErrorMessage("Error", "Error", "Expense Object Can Not Be Null");
return(Task.FromResult(_list));
}
if (_dto.vehicle_id > 0)
{
if (_dto.driver_id == 0)
{
AddErrorMessage("Error", "Error", "No Driver Attached ");
return(Task.FromResult(_list));
}
}
if (_dto.expense_date == null)
{
AddErrorMessage("Error", "Error", "Expense Date Is Missing");
return(Task.FromResult(_list));
}
if (string.IsNullOrEmpty(_dto.voucher_no))
{
AddErrorMessage("Error", "Error", "Voucher No Cannot Be Empty");
return(Task.FromResult(_list));
}
try
{
string _sql = null;
using (var _trans = new ZUpdateContext())
{
var _driver = _trans.Context.DRIVERS.Where(e => e.driver_id == _dto.driver_id & e.delete_id == 0).FirstOrDefault();
var _vehicle = _trans.Context.VEHICLES.Where(e => e.vehicle_id == _dto.vehicle_id & e.delete_id == 0).FirstOrDefault();
if (_vehicle == null)
{
AddErrorMessage("Error", "Error", "Unable To Find Vehicle Object");
_trans.RollBack();
return(Task.FromResult(_list));
}
if (_vehicle.vehicle_id > 0)
{
if (_driver == null & _vehicle.is_hired_id < 2)
{
AddErrorMessage("Error", "Error", "Unable To Find driver Object");
_trans.RollBack();
return(Task.FromResult(_list));
}
}
vh_expense_trans_voucherC _voucher = new vh_expense_trans_voucherC()
{
driver_id = _dto.driver_id,
driver_name = _driver == null ? null : _driver.driver_name.Trim(),
expense_date = _dto.expense_date.Value,
expense_fs_id = fn.GetFSID(_dto.expense_date.Value),
fs_timestamp = fnn.GetUnixTimeStamp(),
server_edate = fnn.GetServerDate(),
vehicle_id = _dto.vehicle_id,
vehicle_plate_no = _vehicle.vehicle_plate_no.Trim(),
created_by_user_id = m_logged_user.user_id,
m_partition_id = string.Format("{0}{1}", _dto.expense_date.Value.Year, _dto.expense_date.Value.Month).ToInt32(),
voucher_no = _dto.voucher_no,
user_id = m_logged_user.user_id,
user_name = m_logged_user.user_name,
voucher_total_amount = _dto.expense_trans_collection.Sum(g => g.expense_amount),
};
_trans.Context.EXPENSE_TRANSACTIONS_VOUCHERS.Add(_voucher);
var _retVal = _trans.Context.SaveChangesWithDuplicateKeyDetected();
if (_retVal == null || _retVal.Value == true)
{
AddErrorMessage("Duplicate Key Error", "Duplicate Key Error", "You Have Entered A Duplicate Expense Transaction");
_list = null;
_trans.RollBack();
return(Task.FromResult(_list));
}
vh_expense_typeC _exp_type_obj = null;
_list = new List <vh_expense_transC>();
List <vh_expense_trans_fieldC> extra_field_list = new List <vh_expense_trans_fieldC>();
foreach (var _e in _dto.expense_trans_collection)
{
_exp_type_obj = _trans.Context.EXPENSE_TYPES.Where(e => e.exp_type_id == _e.exp_type_id & e.delete_id == 0).FirstOrDefault();
if (_vehicle.vehicle_id > 0)
{
switch (_exp_type_obj.exp_cat)
{
case em.vehicle_expense_categoryS.fuel:
case em.vehicle_expense_categoryS.vehicle_hire:
{
_sql = string.Format("select count(expense_id) from {0} where expense_fs_id=@v1 and " +
"vehicle_id=@v2 and exp_type_id=@v3 and delete_id=0",
FleetManager.DbBase.tableNames.expense_trans_tb.ToDbSchemaTable());
object _db_obj_result = _trans.Context.Database.Connection.ExecuteScalar(_sql,
new
{
v1 = fn.GetFSID(_voucher.expense_date.Value),
v2 = _e.vehicle_id,
v3 = _exp_type_obj.exp_type_id
}, _trans.Context.Database.GetDbTransaction());
if (_db_obj_result != null && _db_obj_result.ToInt32() > 0)
{
if (_exp_type_obj.exp_cat == em.vehicle_expense_categoryS.vehicle_hire)
{
AddErrorMessage("Duplicate Vehicle Hire", "Duplicate Vehicle Hire", "You Have Already Made a Vehicle Hire Entry For This Vehicle On The Selected Date");
}
else
{
AddErrorMessage("Duplicate Fuel Entry", "Duplicate Fuel Entry", "You Have Already Made a Fuel Entry For This Vehicle On The Selected Date");
}
_list = null;
_trans.RollBack();
return(Task.FromResult(_list));
}
break;
}
}
}
var _exp_trans = new vh_expense_transC()
{
exp_type_id = _e.exp_type_id,
exp_type_name = _exp_type_obj.exp_type_name,
driver_id = _dto.driver_id,
driver_name = _driver == null ? null : _driver.driver_name,
expense_amount = _e.expense_amount,
expense_date = _voucher.expense_date.Value,
expense_details = _e.expense_details,
expense_fs_id = fn.GetFSID(_voucher.expense_date.Value),
exp_type_cat_id = _exp_type_obj.exp_cat_id,
fs_timestamp = fnn.GetUnixTimeStamp(),
server_edate = fnn.GetServerDate(),
vehicle_id = _dto.vehicle_id,
vehicle_cat_id = _vehicle.vehicle_cat_id,
vehicle_plate_no = _vehicle.vehicle_plate_no.Trim(),
created_by_user_id = m_logged_user.user_id,
repair_action_type_id = _e.repair_action_type_id,
repair_action_type_name = _e.repair_action_type_name,
m_partition_id = string.Format("{0}{1}", _dto.expense_date.Value.Year, _dto.expense_date.Value.Month).ToInt32(),
user_id = m_logged_user.user_id,
user_name = m_logged_user.user_name,
voucher_id = _voucher.voucher_id,
voucher_no = _voucher.voucher_no,
project_id = _e.project_id,
project_name = _e.project_name,
team_leader_id = _e.team_leader_id,
team_leader_name = _e.team_leader_name,
vh_owner_id = _e.vh_owner_id,
vh_owner_name = _e.vh_owner_name,
fuel_station_id = _e.fuel_station_id,
fuel_station_name = _e.fuel_station_name,
mechanic_id = _e.mechanic_id,
mechanic_name = _e.mechanic_name,
};
if (_vehicle.is_hired_id == 2 | _vehicle.vehicle_id == -111)
{
_exp_trans.vehicle_cat_id = _e.vehicle_cat_id;
_exp_trans.vehicle_plate_no = _e.vehicle_plate_no;
}
_trans.Context.EXPENSE_TRANSACTIONS.Add(_exp_trans);
_trans.Context.SaveChanges();
_list.Add(_exp_trans);
if (_e.extra_fields_collection != null && _e.extra_fields_collection.Count > 0)
{
vh_expense_trans_fieldC _ex_field_obj = null;
foreach (var k in _e.extra_fields_collection)
{
_ex_field_obj = new vh_expense_trans_fieldC()
{
created_by_user_id = m_logged_user.user_id,
expense_id = _exp_trans.expense_id,
server_edate = fnn.GetServerDate(),
fs_timestamp = fnn.GetUnixTimeStamp(),
exp_type_id = _exp_trans.exp_type_id,
et_field_id = k.et_field_id,
et_field_item_id = k.et_field_item_id,
field_name = k.field_name,
field_value = k.field_value,
voucher_id = _voucher.voucher_id
};
_trans.Context.EXPENSE_TRANSACTIONS_FIELDS.Add(_ex_field_obj);
_trans.Context.SaveChanges();
extra_field_list.Add(_ex_field_obj);
}
string _json_data = JsonConvert.SerializeObject(extra_field_list);
_sql = string.Format("update {0} set json_extra_fields_info = @v1," +
" fs_timestamp = @v2 where expense_id = {1} and delete_id = 0 ",
_table_name.ToDbSchemaTable(), _exp_trans.expense_id);
_trans.Context.Database.Connection.Execute(_sql, new
{
v1 = _json_data,
v2 = fnn.GetUnixTimeStamp(),
}, _trans.Context.Database.GetDbTransaction());
_exp_trans.json_extra_fields_info = _json_data;
_trans.Context.SaveChanges();
}
}
_trans.Context.SaveChanges();
_trans.Commit();
}
}
catch (SqlException ex)
{
_list = null;
LoggerX.LogException(ex);
}
catch (DbException ex)
{
_list = null;
LoggerX.LogException(ex);
}
catch (Exception ex)
{
_list = null;
LoggerX.LogException(ex);
}
if (_list != null)
{
Task.Run(() =>
{
fnn.CreateCreditorInvoice(_list);
});
}
return(Task.FromResult(_list));
}
public Task<vehicleC> Update(dto_vehicle_updateC _dto)
{
vehicleC _existing = null;
if (fnn.LOGGED_USER.DoesNotHaveRight(em.user_rights_types.can_edit_vehicle))
{
AddErrorMessage("Limited Rights Error", "Rights Error", "You Can Not Perform This Operation");
return Task.FromResult(_existing);
}
if (_dto == null)
{
AddErrorMessage("Update Error", "Save Error", "Vehicle Object Is Null!");
_existing = null;
return Task.FromResult(_existing);
}
if (_dto.vehicle_id == 0)
{
AddErrorMessage("Update Error", "Save Error", "Vehicle Id Is Null!");
_existing = null;
return Task.FromResult(_existing);
}
//if(_dto.driver_id == 0)
//{
// AddErrorMessage("Error", "Error", "Driver Id Is Missing");
// return Task.FromResult(_existing);
//}
try
{
using (var _trans = new ZUpdateContext())
{
_existing = _trans.Context.VEHICLES.Where(e => e.vehicle_id == _dto.vehicle_id & e.delete_id == 0).FirstOrDefault();
if (_existing == null)
{
_existing = null;
AddErrorMessage("Update Error", "Save Error", "Unable To Find Vehicle Object");
return Task.FromResult(_existing);
}
if(_existing.vehicle_plate_no.ToLower()!=_dto.vehicle_plate_no.ToLower())
{
var _ret = DbHelper.UpdatePrimaryKeyColumn(new DbHelperPrimarykeyUpdateC
{
col_to_update = "vehicle_plate_no",
new_col_value = _dto.vehicle_plate_no.Trim().ToUpper(),
table_name = DbHelper.GetTableSchemaName(_table_name),
pk_col_name = "vehicle_id",
pk_id = _dto.vehicle_id
}, _trans.Context);
if (_ret == null || _ret.Value == false)
{
AddErrorMessage("Error", "Update Error", "Vehicle Plate No Already Exists");
_existing = null;
_trans.RollBack();
return Task.FromResult(_existing);
}
else
{
_trans.Context.SaveChanges();
_existing = _trans.Context.VEHICLES.Where(e => e.vehicle_id == _dto.vehicle_id & e.delete_id == 0).FirstOrDefault();
}
}
SimpleMapper.PropertyMap(_dto, _existing);
_trans.Context.VEHICLES.AddOrUpdateExtension(_existing);
_trans.Context.SaveChanges();
_trans.Commit();
return Task.FromResult(_existing);
}
}
catch (SqlException ex)
{
_existing = null;
LoggerX.LogException(ex);
}
catch (DbException ex)
{
_existing = null;
LoggerX.LogException(ex);
}
catch (Exception ex)
{
_existing = null;
LoggerX.LogException(ex);
}
return Task.FromResult(_existing);
}
public Task <projectC> Update(dto_project_updateC _dto)
{
projectC _existing = null;
if (_dto == null)
{
AddErrorMessage("Update Error", "Save Error", "Driver Object Is Null!");
_existing = null;
return(Task.FromResult(_existing));
}
if (_dto.project_id == 0)
{
AddErrorMessage("Error", "Error", "Project Id Is Missing");
return(Task.FromResult(_existing));
}
if (string.IsNullOrEmpty(_dto.project_name))
{
AddErrorMessage("Error", "Error", "Project Name Is Missing");
return(Task.FromResult(_existing));
}
try
{
using (var _trans = new ZUpdateContext())
{
_existing = _trans.Context.PROJECTS.Where(e => e.project_id == _dto.project_id & e.delete_id == 0).FirstOrDefault();
if (_existing == null)
{
_existing = null;
AddErrorMessage("Update Error", "Save Error", "Unable To Find Project Object");
return(Task.FromResult(_existing));
}
if (_existing.project_name.ToLower() != _dto.project_name.ToLower())
{
var _ret = DbHelper.UpdatePrimaryKeyColumn(new DbHelperPrimarykeyUpdateC
{
col_to_update = "project_name",
new_col_value = _dto.project_name.Trim().ToProperCase(),
table_name = DbHelper.GetTableSchemaName(_table_name),
pk_col_name = "project_id",
pk_id = _dto.project_id
}, _trans.Context);
if (_ret == null || _ret.Value == false)
{
AddErrorMessage("Error", "Update Error", "Project Name Already Exists");
_existing = null;
_trans.RollBack();
return(Task.FromResult(_existing));
}
else
{
_trans.Context.SaveChanges();
_existing = _trans.Context.PROJECTS.Where(e => e.project_id == _dto.project_id & e.delete_id == 0).FirstOrDefault();
}
}
SimpleMapper.PropertyMap(_dto, _existing);
_trans.Context.PROJECTS.AddOrUpdateExtension(_existing);
_trans.Context.SaveChanges();
_trans.Commit();
return(Task.FromResult(_existing));
}
}
catch (SqlException ex)
{
_existing = null;
LoggerX.LogException(ex);
}
catch (DbException ex)
{
_existing = null;
LoggerX.LogException(ex);
}
catch (Exception ex)
{
_existing = null;
LoggerX.LogException(ex);
}
return(Task.FromResult(_existing));
}
public Task <vh_expense_type_field_d_itemC> UpdateExpenseTypeFieldItem(dto_expense_type_field_item_updateC _dto)
{
vh_expense_type_field_d_itemC _existing = null;
if (fnn.LOGGED_USER.DoesNotHaveRight(em.user_rights_types.can_create_expense_type_field_item))
{
_existing = null;
AddErrorMessage("Limited Rights Error", "Rights Error", "You Can Not Perform This Operation");
return(Task.FromResult(_existing));
}
if (_dto == null)
{
AddErrorMessage("Update Error", "Save Error", "Object Is Null!");
_existing = null;
return(Task.FromResult(_existing));
}
if (_dto.et_field_item_id == 0)
{
AddErrorMessage("Update Error", "Save Error", "Expense Type Field Item Id Is Null!");
_existing = null;
return(Task.FromResult(_existing));
}
if (string.IsNullOrEmpty(_dto.et_field_item_name))
{
AddErrorMessage("Error", "Error", "Expense Type Field Name Is Missing");
return(Task.FromResult(_existing));
}
try
{
using (var _trans = new ZUpdateContext())
{
_existing = _trans.Context.EXPENSE_FIELD_TYPE_ITEMS.Where(e => e.et_field_item_id == _dto.et_field_item_id & e.delete_id == 0).FirstOrDefault();
if (_existing == null)
{
_existing = null;
AddErrorMessage("Update Error", "Save Error", "Unable To Find Vehicle Object");
return(Task.FromResult(_existing));
}
if (_existing.et_field_item_name.ToLower() != _dto.et_field_item_name.ToLower())
{
var _ret = DbHelper.UpdatePrimaryKeyColumn(new DbHelperPrimarykeyUpdateC
{
col_to_update = "et_field_item_name",
new_col_value = _dto.et_field_item_name.Trim().ToProperCase(),
table_name = DbHelper.GetTableSchemaName(table_name),
pk_col_name = "et_field_item_id",
pk_id = _dto.et_field_item_id
}, _trans.Context);
if (_ret == null || _ret.Value == false)
{
AddErrorMessage("Error", "Update Error", "Expense Type Field Item Name Already Exists");
_existing = null;
_trans.RollBack();
return(Task.FromResult(_existing));
}
else
{
_trans.Context.SaveChanges();
_existing = _trans.Context.EXPENSE_FIELD_TYPE_ITEMS.Where(e => e.et_field_item_id == _dto.et_field_item_id & e.delete_id == 0).FirstOrDefault();
}
}
SimpleMapper.PropertyMap(_dto, _existing);
// _existing.fs_timestamp = fnn.GetUnixTimeStamp();
_trans.Context.EXPENSE_FIELD_TYPE_ITEMS.AddOrUpdateExtension(_existing);
_trans.Context.SaveChanges();
_trans.Commit();
return(Task.FromResult(_existing));
}
}
catch (SqlException ex)
{
_existing = null;
LoggerX.LogException(ex);
}
catch (DbException ex)
{
_existing = null;
LoggerX.LogException(ex);
}
catch (Exception ex)
{
_existing = null;
LoggerX.LogException(ex);
}
return(Task.FromResult(_existing));
}
public Task <bool> Update(dto_target_group_updateC _dto)
{
bool _updated = false;
if (string.IsNullOrEmpty(_dto.target_gp_name))
{
AddErrorMessage("Update Error", "Save Error", "Target Area Name Is Null!");
return(Task.FromResult(_updated));
}
if (fnn.LOGGED_USER.DoesNotHaveRight(em.right_menu_types.can_edit_target_group_info))
{
_updated = false;
AddErrorMessage("Limited Rights Error", "Limited Rights Error", "You Are Not Authorized To Perform This Operation");
return(Task.FromResult(_updated));
}
#region _image_section
string _imageUrl = null;
target_groupC _obj = null;
if (!string.IsNullOrEmpty(_dto.target_gp_image_base_64))
{
string _imageFilePath = string.Empty;
string _file_extension = string.Empty;
if (string.IsNullOrEmpty(_dto.image_file_extension))
{
AddErrorMessage("Insert Error", "Save Error", "Grantee Image File Extension Cannot Be Empty");
return(Task.FromResult(_updated));
}
try
{
if (_dto.image_file_extension.IndexOf('.') == -1)
{
_file_extension = string.Format(".{0}", _dto.image_file_extension);
}
else
{
_file_extension = _dto.image_file_extension;
}
if (!fnn.IsValidImageFileExtension(_file_extension))
{
AddErrorMessage("Insert Error", "Save Error", "Grantee Image File Extension Is Invalid");
return(Task.FromResult(_updated));
}
var _image_bytes = System.Convert.FromBase64String(_dto.target_gp_image_base_64);
if (_image_bytes == null || _image_bytes.Length == 0)
{
throw new Exception("Error Getting Grantee Image From Base64 String");
}
var rootPath = HostingEnvironment.MapPath("~/ImageAssets/");
string _file_name = string.Format("tg-{0:yyyy-MM-dd_hh-mm-ss-tt}{1}", DateTime.Now, _file_extension);
_imageFilePath = Path.Combine(rootPath, Path.GetFileName(_file_name));
File.WriteAllBytes(_imageFilePath, _image_bytes);
_imageUrl = fnn.CreateImageAssetUrl(_file_name);
}
catch (Exception ex)
{
AddErrorMessage("Thrown Execption", "Thrown Exception", ex.Message);
return(Task.FromResult(_updated));
}
}
#endregion
using (var _trans = new ZUpdateContext())
{
var _existing = _trans.Context.TARGET_GROUPS.Where(e => e.target_gp_id == _dto.target_gp_id & e.delete_id == 0).FirstOrDefault();
if (_existing == null)
{
_updated = false;
AddErrorMessage("Update Error", "Save Error", "Unable To Find Facilitator Object");
return(Task.FromResult(_updated));
}
_obj = _existing;
if (_existing.target_gp_name.ToLower() != _dto.target_gp_name.ToLower())
{
var _ret = DbHelper.UpdatePrimaryKeyColumn(new DbHelperPrimarykeyUpdateC
{
col_to_update = "target_gp_name",
new_col_value = _dto.target_gp_name.Trim().ToProperCase(),
table_name = _table_name,
pk_col_name = "target_gp_id",
pk_id = _dto.target_gp_id
}, _trans.Context);
if (_ret == null || _ret.Value == false)
{
AddErrorMessage("Error", "Update Error", "Target Area Name Already Exists");
_updated = false;
return(Task.FromResult(_updated));
}
else
{
_updated = true;
_trans.Context.SaveChanges();
}
}
_updated = true;
if (_updated)
{
List <DbParameter> _para = new List <DbParameter>();
_para.Clear();
_para.Add(fnn.GetDbParameters("@id", _existing.target_gp_id));
_para.Add(fnn.GetDbParameters("@v2", fnn.GetServerDate().ToUnixTimestamp()));
_para.Add(fnn.GetDbParameters("@v3", string.IsNullOrEmpty(_dto.alias) ? string.Empty : _dto.alias));
_para.Add(fnn.GetDbParameters("@v4", string.IsNullOrEmpty(_imageUrl) ? string.Empty : _imageUrl));
//
var _sql = string.Format(string.Format("update {0} set fs_timestamp=@v2,alias=@v3,target_gp_image_url=@v4 where target_gp_id = @id and delete_id = 0", _table_name));
_trans.Context.Database.ExecuteSqlCommand(_sql, _para.ToArray());
_trans.Context.SaveChanges();
int _cat_type_id = em.resource_cat_typeS.target_gp.ToInt32();
var _r_list = (from k in _trans.Context.VOICE_RESOURCE_CATEGORIES
where k.resource_cat_type_id == _cat_type_id & k.resource_cat_id == _obj.target_gp_id
& k.delete_id == 0
select k).ToList();
foreach (var _v in _r_list)
{
_para.Clear();
_para.Add(fnn.GetDbParameters("@v1", _existing.target_gp_id));
_para.Add(fnn.GetDbParameters("@v2", fnn.GetServerDate().ToUnixTimestamp()));
_para.Add(fnn.GetDbParameters("@v3", string.IsNullOrEmpty(_imageUrl) ? string.Empty : _imageUrl));
_para.Add(fnn.GetDbParameters("@v4", _dto.target_gp_name.Trim().ToProperCase()));
_sql = string.Format(string.Format("update {0} set fs_timestamp=@v2,resource_cat_img_url=@v3" +
",resource_cat_name=@v4 where un_id = @v1 and delete_id = 0", DbHelper.GetTableSchemaName("voice_resource_cat_tb")));
_trans.Context.Database.ExecuteSqlCommand(_sql, _para.ToArray());
_trans.Context.SaveChanges();
}
_trans.Commit();
}
}
return(Task.FromResult(_updated));
}
