public long SaveFleetModels(ClsFleetModels objSave)
        {
            try
            {
                using (TransactionScope scope = new TransactionScope())
                {
                    using (this.objDataContext = new FleetModelsDataContext(Functions.StrConnection))
                    {
                        var result = this.objDataContext.InsertOrUpdateFleetModels(objSave.lgId, objSave.strFleetModelsName, mySession.Current.UserId, PageMaster.FleetModels).FirstOrDefault();
                        if (result != null)
                        {
                            objSave.lgId = result.InsertedId;
                        }
                    }

                    scope.Complete();
                }

                return(objSave.lgId);
            }
            catch (Exception ex)
            {
                Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetModels, mySession.Current.UserId);
                return(0);
            }
        }
        public ClsFleetModels GetFleetModelsByFleetModelsId(long lgFleetModelsId)
        {
            ClsFleetModels objClsFleetModels = new ClsFleetModels();

            try
            {
                using (this.objDataContext = new FleetModelsDataContext(Functions.StrConnection))
                {
                    GetFleetModelsByIdResult item = this.objDataContext.GetFleetModelsById(lgFleetModelsId).ToList().FirstOrDefault();
                    if (item != null)
                    {
                        objClsFleetModels.lgId = item.Id;
                        objClsFleetModels.strFleetModelsName = item.FleetModelsName;
                    }
                }
            }
            catch (Exception ex)
            {
                Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetModels, mySession.Current.UserId);
            }

            return(objClsFleetModels);
        }